Sunday, February 17, 2013

0 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)

image

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';

 

image

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.

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates