DBA Hub

📋Steps in this guide1/1

Modify moving window baseline size

-- Check the current moving window baseline size:

oracle configurationintermediate
by OracleDba
13 views
1

Modify moving window baseline size

Code/Command (click line numbers to comment):

1
2
3
4
-- 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);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!