Oracle AWR Retention period ..
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;
SNAPSHOT_INTERVAL RETENTION_INTERVAL
----------------- ------------------
60 11520 <<<<In min
set lines 200
col snap_interval format a20
col retention format a20
select * from dba_hist_wr_control;
DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID
---------- -------------------- -------------------- ---------------------------------------- ----------
2955063305 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT 0
^
Days
To Change 15 minutes and retention to 30 days (30x24x60 = 43200)
SQL> exec dbms_workload_repository.modify_snapshot_settings(interval => 15, retention => 43200)
No comments:
Post a Comment