oracle@USDB:~> ll *awr*
-rw-r--r-- 1 oracle oinstall 2369 2014-08-21 17:26 dbmsnoawr.plb
--执行dbmsnoawr.plb，其实质是添加了一个名为dbms_awr的pkg到当前数据库
sys@HKBO5> @dbmsnoawr.plb
Package created.
Package body created.
sys@HKBO5> exec dbms_awr.disable_awr();
PL/SQL procedure successfully completed.
sys@HKBO5> desc dbms_awr
FUNCTION AWR_ENABLED RETURNS BOOLEAN
FUNCTION AWR_STATUS RETURNS VARCHAR2
PROCEDURE DISABLE_AWR
PROCEDURE ENABLE_AWR
--查看disable后awr的状态，返回值为disable
sys@HKBO5> select dbms_awr.awr_status from dual;
AWR_STATUS
-------------------------------------------------------------
DISABLED
--查询awr的数据字典，发现SNAP_INTERVAL变成了0值
sys@HKBO5> select * from dba_hist_wr_control;
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- ---------------------------------------- ---------------------------------------- ----------
733951103 +40150 00:00:00.0 +00007 00:00:00.0 DEFAULT
--再次enable awr
sys@HKBO5> exec dbms_awr.enable_awr();
PL/SQL procedure successfully completed.
--此时SNAP_INTERVAL采样恢复到了缺省值，也就是说过程DISABLE_AWR修改了SNAP_INTERVAL设置
sys@HKBO5> select * from dba_hist_wr_control;
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- ---------------------------------------- ---------------------------------------- ----------
733951103 +00000 01:00:00.0 +00007 00:00:00.0 DEFAULT
4、卸载awr
卸载awr通用用于awr相关功能或特性异常的时候。通过先卸载在安装来达到使awr特性正常化。下面给出步骤，不再演示。
卸载awr脚本：$ORACLE_HOME/rdbms/admin/catnoawr.sql
安装awr脚本：$ORACLE_HOME/rdbms/admin/catawr.sql
sqlplus /nolog
connect / as sysdba
show parameters statistics_level
alter system set statistics_level=basic scope=spfile;
shutdown immediate
startup restrict
$ORACLE_HOME/rdbms/admin/catnoawr
shutdown immediate
startup
5、参考
Doc ID 1909073.1
Doc ID 787409.1