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/
ReplyDelete