While modify the AWR retention period, I get the error message
ORA-13541: system moving window baseline size (691200) greater than retention
(604800)
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';
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.
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/
ReplyDeleteI 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
ReplyDeleteFinally, 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
ReplyDeleteThe 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