1.创建基线
SQL> exec dbms_workload_repository.create_baseline(start_snap_id=>2546,end_snap_id=>2548,baseline_name=>'peak baseline',dbid=>1725496767,expiration=>8);
2.删除基线
SQL> exec dbms_workload_repository.drop_baseline(baseline_name => 'peak mondays');
3.重命名基线
SQL> exec dbms_workload_repository.rename_baseline(old_baseline_name=>'peak baseline',new_baseline_name=>'peak mondays',dbid=>1725496767);
4.查看基线统计信息
SQL> exec dbms_workload_repository.select_baseline_metrics(baseline_name=>'peak mondays',dbid=>1725496767,instance_num=>1);
5.修改移动基线的窗口大小
SQL> exec dbms_workload_repository.modify_baseline_window_size(window_size=>7,dbid=>1725496767);
6.查看基线
SQL> select dbid,baseline_id,baseline_name,baseline_type,start_snap_id,start_snap_time,end_snap_id,end_snap_time,moving_window_size,creation_time,expiration,template_name,last_time_computed from dba_hist_baseline; DBID BASELINE_ID BASELINE_NAME BASELINE_TYPE START_SNAP_ID START_SNAP_TIME END_SNAP_ID END_SNAP_TIME MOVING_WINDOW_SIZE CREATION_TIME EXPIRATION TEMPLATE_NAME LAST_TIME_COMPUTED ---------- ----------- -------------------- ------------- ------------- ------------------------- ----------- ------------------------- ------------------ ------------------------- ---------- -------------- ------------------- 1725496767 1 peak baseline STATIC 2546 05-NOV-15 12.00.57.896 PM 2548 05-NOV-15 02.00.01.146 PM 05-NOV-15 8 1725496767 0 SYSTEM_MOVING_WINDOW MOVING_WINDOW 2358 28-OCT-15 04.00.39.626 PM 2549 05-NOV-15 02.31.07.474 PM 8 21-JUL-15 SQL>