To create perfstat schema
cd $ORACLE_HOME/rdbms/admin/
@spcreate.sql
To drop perfstat schema
@spdrop.sql
To schedule a collection of statistic every hour
@spauto.sql
to create a report between two times
@spreport.sql
To purge information in range of time
@sppurge.sql
To purge all information recorded within perfstat
@sptrunc.sql
For creating a instance report
@sprepins.sql
For creating a report about a sql sentence
@sprepsql.sql
To take a snapshot.
exec statspack.snap;
