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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s