Statspack

Install:

SQL> @?/rdbms/admin/spcreate.sql

Create snapshot

SQL> execute statspack.snap;

Run report (need: begin snap, and snap, report_file)

SQL> @?/rdbms/admin/spreport.sql

Run SQL report (need: begin snap, and snap, hash value for SQL, report_file)

SQL> @?/rdbms/admin/sprepsql.sql

Delete snapshots

SQL> @?/rdbms/admin/sppurge.sql

Truncate all stats

SQL> @?/rdbms/admin/sptrunc.sql

Drop Statspack

SQL> @?/rdbms/admin/spdrop.sql