While modify the AWR retention period, I get the error message
ORA-13541: system moving window baseline size (691200) greater than retention
(604800)
The 604800 is actually the seconds from the retention period I want to set. 10080 minutes * 60 = 604800.
The current moving window can be get from DBA_HIST_BASELINE.
SELECT moving_window_size
FROM dba_hist_baseline
WHERE baseline_type = 'MOVING_WINDOW';
We can use DBMS_WORKLOAD_REPOSITORY.modify_baseline_window_size to change the moving window.
exec DBMS_WORKLOAD_REPOSITORY.modify_baseline_window_size( window_size =>7);
SELECT moving_window_size
FROM dba_hist_baseline
WHERE baseline_type = 'MOVING_WINDOW';
After window is updated, we can update the retention window.
0 comments:
Post a Comment