Baseline管理

2015-11-05 15:42 abce 阅读(535) 评论(0) 编辑收藏举报

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>