14 ORA-13541: system moving window baseline size (X) greater than retention (X)

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.