ORA-13541: system moving window baseline size (691200) greater than retention
Cause:
Retention should not be less than baseline window
Error is triggered due to retention !< baseline
kIsH@Xhydra<>EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 60, retention => 1440);
BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 60, retention => 1440); END;
*
ERROR at line 1:
ORA-13541: system moving window baseline size (691200) greater than retention
(86400)
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 213
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 265
ORA-06512: at line 1
kIsH@Xhydra<>!oerr ora 13541
13541, 00000, "system moving window baseline size (%s) greater than retention (%s)"
// *Cause: The system moving window baseline size must be less than the
// retention setting. The specified window size or retention
// violate this.
// *Action: Check the moving window baseline size or retention.
Action:
Baseline window is set to 8 days and of course default value. Convert the days to seconds
kIsH@Xhydra<>EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_BASELINE_WINDOW_SIZE(window_size => 8);
PL/SQL procedure successfully completed.
kIsH@Xhydra<>select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline;
BASELINE_TYPE MOVING_WINDOW_SIZE
------------- ------------------
MOVING_WINDOW 8
MOVING_WINDOW 8
kIsH@Xhydra<>select 8 * 24 * 60 day_in_seconds from dual;
DAY_IN_SECONDS
----------
11520
Use the value 11520 seconds in retention
kIsH@Xhydra<>EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 60, retention => 11520);
PL/SQL procedure successfully completed.