Statspack

Statspack

cd $ORACLE_HOME/rdbms/admin/

For creating perfstat schema

@spcreate.sql

For dropping perfstat schema

@spdrop.sql

To schedule a collection of statistic every hour  

@spauto.sql

to creating 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 

For taking a snapshot.  

exec statspack.snap;

To list all generated snapshots
cd $ORACLE_HOME/rdbms/admin
sqlplus perfstat/perfstat
select    
    snap_id,       
    snap_level,    
    to_char(snap_time,'HH24:MI:SS DD-MM-YYYY') "Snap_Time"
from stats$snapshot,  v$database
order by snap_id;