Which statistic changed?

Oracle maintains statistics about resource usage within database sessions. This utility allows you to easily see what changed.

That can lead you to the source of performance problems, and maybe a fix.

First, we initialise the PL/SQL arrays for the test session ID.

Run something in the test session:

What’s changed?

To use the utility, first clone this git repo to a suitable location on your test server:

git clone https://github.com/johnthomas22/get_stats.git

Next, install the objects in your database:

sqlplus / as sysdba @get_stats

Samples for the blocks to run to get results are in get_stats_test.sql. Good hunting!

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close