Sunday, February 17, 2013

4 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

4 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
  2. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Full money back guarantee

    ReplyDelete
  3. Finally, to avoid misunderstandings about cost, be sure to tell the moving company exactly which services you want and what type of items they will be moving. house moving

    ReplyDelete
  4. The movers and packers will actually pack your belonging for you, if you purchase the service from the moving company. This kind of door to door service is great, especially if the moving quotes are within your budget. Relocation companies

    ReplyDelete

 

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