日期:2014-05-16 浏览次数:20489 次
创建AWR 基线(baseline)
查找快照号码
select * from DBA_HIST_SNAPSHOT;
创建awr基线
exec DBMS_WORKLOAD_REPOSITORY. CREATE_BASELINE (
start_snap_id IN NUMBER,
end_snap_id IN NUMBER,
baseline_name IN VARCHAR2);
eg:
exec DBMS_WORKLOAD_REPOSITORY. CREATE_BASELINE (
148 ,
149 ,
'awr' );
通过 dba_hist_baseline 视图可查看已经创建的基线
SQL> select * from DBA_HIST_BASELINE;
DBID BASELINE_ID BASELINE_NAME
---------- ----------- --------------------
2546074315 1 awr
补充:<具体见 Oracle Database PL/SQL Packages and Types Reference >
Managing Baselines with PL/SQL DBMS_WORKLOAD_REPOSITORY Package
Procedure Name Description
CREATE_BASELINE : Create a single AWR baseline
DROP_BASELINE : Drop a single AWR baseline
RENAME_BASELINE : Rename a baseline
CREATE_BASELINE_TEMPLATE : Create a baseline template
DROP_BASELINE_TEMPLATE : Drop a baseline template
MODIFY_BASELINE_WINDOW_SIZE : Modify the window size for the Default Moving Window Baseline