Statspack - How to

SQL> CONN perfstat/perfstat
Connected.
SQL> EXEC STATSPACK.snap; 
PL/SQL procedure successfully completed.

@spauto.sql   < for taking snapshot automatically every hour
@sppurge.sql  < for deleting unwanted snaps
@spreport     < for report generation