Modify moving window baseline size - Oracle Database Script. -- Check the current moving window baseline size: select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline; -- Modify window_size to (7 days): execute dbms_workload_repository.modify_baseline_window_size(window_size=> 7);
-- Check the current moving window baseline size: select BASELINE_TYPE,MOVING_WINDOW_SIZE from dba_hist_baseline; -- Modify window_size to (7 days): execute dbms_workload_repository.modify_baseline_window_size(window_size=> 7);