DBA Hub

📋Steps in this guide1/1

View/modify AWR retention

-- View current AWR retention period

oracle configurationintermediate
by OracleDba
13 views
1

View/modify AWR retention

Code/Command (click line numbers to comment):

1
2
3
4
5
-- View current AWR retention period
select retention from dba_hist_wr_control;
-- Modify retention period to 7 days and interval to 30 min
select dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080);
NOTE - 7 DAYS = 7*24*3600= 10080 minutes

Comments (0)

Please to add comments

No comments yet. Be the first to comment!