Sunday, February 17, 2013

1 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

1 comments:

  1. The following time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I mean, I do know it was my option to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you would fix should you werent too busy in search of attention. https://royalcbd.com/product/cbd-oil-500mg/

    ReplyDelete

 

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