创建AWR 基线（baseline）
创建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
