AWR/ADDM/Statspack referance

Statspack report:

Sql>@? /rdbms/admin/spdrop.sql

Sql>@? /rdbms/admin/spcreate.sql

Snapshot catch

Sql> exec statspack.snap

Sql> exec statspack.snap

Sql>@? /rdbms/admin/spreport.sql

sql>@? /rdbms/admin/spauto.sql

AWR:

Sql>alter system set statistics_level = typical/all;

Change the interval/retention period

Sql>exec dbms_workload_repository.modify_snapshot_settings (retention =>43200,interval =>30); (30*24*60 = 43200 30=days,24 = hrs , 60 = minutes)

Sql>exec dbms_workload_repository.create_snapshot;

Sql>select * from dba_hist_snapshot;(display all snapshot)

Sql>select * from dba_hist_wr_contrl;

Sql>@? /rdbms/admin/awrrpt.sql

Sql>select snap_id from dba_hist_snapshot;

ADDM

Sql>@? /rdbms/admin/addmrpt.sql