User Tools

Site Tools


oracle:awr

This is an old revision of the document!


AWR

Actual config

SELECT *
FROM
   dba_hist_wr_control
/

or, only timings:

SELECT
       EXTRACT( DAY FROM snap_interval) *24*60+
       EXTRACT( HOUR FROM snap_interval) *60+
       EXTRACT( MINUTE FROM snap_interval ) "Snapshot Interval",
       EXTRACT( DAY FROM retention) *24*60+
       EXTRACT( HOUR FROM retention) *60+
       EXTRACT( MINUTE FROM retention ) "Retention Interval"
FROM dba_hist_wr_control
/

retention

modify

Modify, units are minutes:

EXECUTE DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
  retention =>  20160);

frequency

Modify, units are minutes:

EXECUTE DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
  INTERVAL  =>  60);

Number of SQL's captured on each snapshot

Modify, units are minutes:

EXECUTE DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
  topnsql  =>  100);
oracle/awr.1422273993.txt.gz · Last modified: 2015/01/26 12:06 by dodger