如何禁用Oracle AWR自动采样功能
来源:互联网 发布:医渡云 人工智能 编辑:程序博客网 时间:2024/04/30 03:27
如何禁用Oracle AWR自动采样功能
链接:http://www.eygle.com/archives/2012/03/disable_enable_awr.html
Rem该脚本包含两个过程和两个函数,通过disable_awr / enable_awr 就可以禁用或者启用AWR采样功能:
Rem dbmsnoawr.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.
Rem
Rem NAME
Rem dbmsnoawr.sql - Declaration of the DBMS_AWR package
Rem
Rem DESCRIPTION
Rem Utilities for disabling and getting status of AWR
Rem
Rem NOTES
Rem
Rem MODIFIED (MM/DD/YY)
Rem gwood 04/13/07 - created
Rem
create or replace package dbms_awr as
-- PACKAGE dbms_awr
-- This package allows users to disable AWR functionality in a Oracle 10g+ database.
-- The use of this package is not resticted by licencing of the Diagnostic Pack.
-- Additionally this package contains two functions that can be used to determine
-- if AWR is currently enabled.
--
-- PROCEDURE dbms_awr.disable_awr
-- PURPOSE: turns off collections into Automatic Workload Repository
-- PARAMETERS: none
procedure disable_awr;
-- PROCEDURE dbms_awr.enable_awr
-- PURPOSE: turns on collections into Automatic Workload Repository. The capture interval
-- is set to the default of 60 minutes.
-- PARAMETERS: none
procedure enable_awr;
-- FUNCTION dbms_awr.awr_enabled
-- PURPOSE: Returns TRUE if Automatic Workload Repository is performing periodic capture.
-- Returns FALSE if Automatic Workload Repository periodic capture is disabled.
-- PARAMETERS: none
function awr_enabled return boolean;
-- FUNCTION dbms_awr.awr_status
-- PURPOSE: Returns 'ENABLED' if Automatic Workload Repository is performing periodic capture.
-- Returns 'DISABLED' if Automatic Workload Repository periodic capture is disabled.
-- PARAMETERS: none
function awr_status return varchar2;
end dbms_awr;
/
create or replace package body dbms_awr wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
27b 1de
XeDco+SpVfG9KEZ2ikXc00yhW88wg2P3AK7bfHRAWE7VX0b1S25KKJCp5VrehjNR9oaXoWT1
GGfYVnyl/lLyux308Fmhfp1y9pjrQyux50RY8xmHmiSG2bFbFs2Upn6MLYcfsqsW+joOTKYe
4TyFpXVqzVWS+Tjt8bcmSiai64IVcdOB3Q7Y6kQ8PGwqXqAiy9sFQKD0X6RC/ePGAQzUKwvS
3L8/hKgjdK9Fgw8bb7v1HTq22OJlAv+R/DYCSK57rPmAkyx/XLuXcPo3hcYs8fvUUAO33szW
gy5zNau9U7xiyAOExBz9Vh0U7EaMRl6rLr6UXpk/0tk3BW0W/GVo3XfdSzUpGN5aKa1xF2Yh
trcMV3KuK/FfIpy0bNDxSQ3LFuOsB8i5xzhj/dCqMxT4dO2awc0hnP3XeLhxWDvcEuqdkR9O
u+Z6US/LtRISXt2I8zFq6/aDSuOXTor9KQ1jYA==
/
SQL> @D:\dbmsnoawr.plb
Package created.
Package body created.
SQL> desc dbms_awr
FUNCTION AWR_ENABLED RETURNS BOOLEAN
FUNCTION AWR_STATUS RETURNS VARCHAR2
PROCEDURE DISABLE_AWR
PROCEDURE ENABLE_AWR
SQL> exec dbms_awr.disable_awr
PL/SQL procedure successfully completed.
SQL> select dbms_awr.awr_status from dual;
AWR_STATUS
-------------------------------------------------------
DISABLED
SQL> exec dbms_awr.enable_awr
PL/SQL procedure successfully completed.
SQL> select dbms_awr.awr_status from dual;
AWR_STATUS
-------------------------------------------------------
ENABLED
这个脚本本质上非常简单,就是通过将快照采样价格设置为0和60来控制禁用和启用的。
PROCEDURE DISABLE_AWR记录供参考
IS
BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 0);
END;
PROCEDURE ENABLE_AWR
IS
BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 60);
END;
- 如何禁用Oracle AWR自动采样功能
- awr采样不自动刷新的问题
- webstorm如何禁用自动保存功能?
- 禁用与卸载Oracle AWR特性
- 禁用与卸载Oracle AWR特性
- oracle awr报告对比功能
- 如何禁用在FilterRow的自动完成功能
- oracle如何生成AWR报告
- 如何生成Oracle AWR报告
- oracle 【AWR】调整AWR数据采样时间间隔及历史快照保留时间
- python脚本自动生成ORACLE AWR报告
- Oracle 11g AWR 系列五:如何生成 AWR 报告?
- oracle AWR深入研究分析,如何使用
- Oracle 数据库中如何收集AWR Report
- 在Oracle如何通过配置可以禁用Form的导出功能(Form-->Export的功能)
- 如何禁用注册表自动修改
- Oracle AWR
- Oracle AWR
- C/C++ 中 const 修饰符用法总结
- 使用Spring进行面向切面编程(AOP)---讲解+代码
- 疯狂程序员(2)
- css基础 内联元素 块元素 盒子模型
- [006] 百度地图移动版API终于发布了(Android) .
- 如何禁用Oracle AWR自动采样功能
- JAVA中使用XFire调用WebService接口
- jquery设置元素的readonly和disabled【转】
- const 修饰函数相关
- seo从业者如何在逆境中求生存
- WinForm应用程序中的ComboBox实现ReadOnly功能
- [007] 如何在Android应用中使用百度地图api .
- hdu 1789 DP
- 【Win7开始的搜索框消失了教你找回】