_____________________________________________________________________________________

Global Docu:
http://docs.oracle.com/cd/B10501_01/server.920/a96533/statspac.htm
http://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html

External Links:
http://www.dbspecialists.com/not-licensed-for-awr-use-statspack-instead/
http://www.muniqsoft.de/tipps/tipps-zu-dba/oracle-tuning/statspack5bea.pdf
_____________________________________________________________________________________

sqlplus / as sysdba

-- P R E P A R E
-- =============
-- <spcreate.sql> will create the PERFSTAT user along with all of the Statspack objects
@?/rdbms/admin/spcreate.sql

-- <spauto.sql> will create a dbms_job that will execute a snapshot every hour
@?/rdbms/admin/spauto.sql

-- To manually create a snapshot, run perfstat.statspack.snap
conn perfstat/<perfstat_pw>
exec perfstat.statspack.snap;


-- G O
-- ===

-- Change the snap level
exec statspack.modify_statspack_parameter(i_snap_level=>6);

-- Run the StatsPack Instance report
@?/rdbms/admin/spreport.sql

-- Run the StatsPack SQL report
@?/rdbms/admin/sprepsql.sql


_____________________________________________________________________________________

GENERAL INFO (DBA_xxx)
======================
col object_name for a40
select object_type, object_name from dba_objects where owner = 'PERFSTAT' order by 1, 2;
select object_name, object_type from dba_objects where owner = 'PERFSTAT' order by 2, 1;
_____________________________________________________________________________________