Statspack summary

This post is a summary of the Oracle Statspack Survival Guide.

To install statspack :

• Create tablespace for it
• @?/rdbms/admin/spcreate (run as sysdba)

To take snaps :

• exec statspack.snap;

To create the report :

• @?/rdbms/admin/spreport.sql