ORA-13541: System Moving Window Baseline Size Greater Than Retention.

Solution :

Let’s check the Moving window size:

SQL> select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline;

BASELINE_TYPE MOVING_WINDOW_SIZE
------------- ------------------
MOVING_WINDOW 8

It is set to 8 days. I.e the moving window size is more than the retention period we are trying to set. So modify the window size to 7 days.

SQL> execute dbms_workload_repository.modify_baseline_window_size(window_size=> 7);

PL/SQL procedure successfully completed.


SQL> select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline;

BASELINE_TYPE MOVING_WINDOW_SIZE
------------- ------------------
MOVING_WINDOW 7

Now try to modify awr snapshot retention:

SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080);

PL/SQL procedure successfully completed.