oracleawrdiff,测试AWREXTRACTAWRBaseline

AWR EXTRACT&AWR Baseline

1.AWR EXTRACT(生产数据库)

--查询是否创建导出目录&＃xff0c;如没有可自行创建一个

create or replace directory IMP_PATH as &＃39;/u01/replay&＃39;;

select DIRECTORY_NAME, DIRECTORY_PATH from

dba_directories;

--查询现有快照点

select min(SNAP_ID) from

sys.wrh$_active_session_history;

select * from dba_hist_active_sess_history &＃xff1b;

--导出快照点11100至11106的性能监视

exec DBMS_SWRF_INTERNAL.AWR_EXTRACT(DMPFILE

&＃61;>&＃39;awr_data_cqabdt0&＃39;,DMPDIR &＃61;>&＃39;IMP_PATH&＃39;,BID &＃61;>11100,EID &＃61;>11106 );

or

&＃64;$ORACLE_HOME/rdbms/admin/awrextr.sql

2.AWR 导入(测试数据库)

select DIRECTORY_NAME, DIRECTORY_PATH from

dba_directories;

exec

DBMS_SWRF_INTERNAL.AWR_LOAD(SCHNAME &＃61;>&＃39;TEST&＃39;,dmpfile

&＃61;>&＃39;awr_data_cqabdt0&＃39;,dmpdir &＃61;>&＃39;IMP_PATH&＃39;);

exec

DBMS_SWRF_INTERNAL.MOVE_TO_AWR (SCHNAME &＃61;> &＃39;TEST&＃39;);

3.AWR Baseline(测试数据库)

set pagesize 0

set linesize 32767

select * from

table(DBMS_WORKLOAD_REPOSITORY.AWR_DIFF_REPORT_HTML(1273272014,1,11100,11102,1273272014,1,11103,11104));

或者

&＃64;$ORACLE_HOME/rdbms/admin/awrddrpt.sql

其他参考

####

#

#/bin/sh

result&＃61;&＃96;sqlplus -s system&＃64;xitest01 <

set pagesize 0

set linesize 32767

select *

from

table(DBMS_WORKLOAD_REPOSITORY.AWR_DIFF_REPORT_HTML(1273272014,1,11100,11102,1273272014,1,11103,11104));

EOF&＃96;

echo

"ok1"

echo

"$result" > awr_baseline_html.html

#通过sh脚本导出html静态网页

#

#

#

###############

##        BEGIN

##                DBMS_SWRF_INTERNAL.AWR_EXTRACT

(DMPFILE &＃61;> &＃39;awr_data.dmp&＃39;,

##                DMPDIR

&＃61;> &＃39;DB_DIR&＃39;, -- Database directory

##                BID

&＃61;> 4283, -- Begin snapshot

##                EID

&＃61;> 4315 -- End snapshot

##                );

##        END;

##        /

##

##        BEGIN

##                DBMS_SWRF_INTERNAL.AWR_LOAD

(SCHEMA &＃61;> &＃39;MYSCHEMA&＃39;,

##                DMPFILE

&＃61;> &＃39;awr_data.dmp&＃39;,

##                DMPDIR

&＃61;> &＃39;DB_DIR&＃39;, -- Database directory );

##        END;

##        /

##

##        BEGIN

##                DBMS_SWRF_INTERNAL.MOVE_TO_AWR

(SCHEMA &＃61;> &＃39;MYSCHEMA&＃39;);

##        END;

##        /

###############