日期:2014-05-16  浏览次数:20482 次

创建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