Monday, May 21, 2018

How to take a manual AWR snapshot

It can be useful to capture precisely a period of activity.
On a new database if there are 30 minutes snapshots taken, a 5 minute load test might be skewed by 25 minutes of inactivity.

To run a proper test, do the following:

EXEC dbms_workload_repository.create_snapshot;
Run test here;
EXEC dbms_workload_repository.create_snapshot;
Now run an AWR report with begin time using the first create_snapshot and end time using the second snapshot.