Oracle AWR and STATSPACK Manual snapshot commands

There are times when you want to manually collect AWR and STATSPACK snapshots, such as when you are experiencing a performance problem or doing a stress test.  You can issue these commands to get a manual AWR or STATSPACK snapshot at whatever elapsed time interval you desire:

AWR manual snapshot:

EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

STATSPACK manual snapshot:

exec statspack.snap;
 

For more information see the book "Oracle Tuning: The Definitive Reference" by Rampant TechPress.