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!
