AWR – Modify snapshot settings

– Default –
AWR Snapshot interval : 60
AWR Snapshot retention: 7 days
Number of Top SQL Sampling: 30

– Change to –
AWR Snapshot interval : 30
AWR Snapshot retention: 30 days
Number of Top SQL Sampling: 50

SQL> BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
INTERVAL => 30, RETENTION => 30*24*60, TOPNSQL => ’50′ );
EDN;
/

– Review AWK setting –
SQL> SELECT * FROM DBA_HIST_WR_CONTROL;

Advertisement