STOP / Disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter


You can stop the ADDM in Oracle 11g using control_management_pack_access initialization parameter. The values permitted for this parameter are
  1. NONE – Both packs are not available
  2. TUNING – Only tuning packs (SQL Tuning advisor, SQLAccess Advisor) are avilable
  3. DIAGNOSTIC+TUNING – This enables Diagnostic (AWR, ADDM) and tuning packs to the database.

By default the database will be enabled with DIAGNOSTIC+TUNING as the value for the parameter.
When you stop/disable the parameter by putting value as NONE the V$ACTIVE_SESSION_HISTORY table will be empty and ASH, AWR report will not show any content.

SQL> show parameter control_management_pack_access

NAME_COL_PLUS_SHOW_PARAM       TYPE        VALUE_COL_PLUS_SHOW_PARAM
------------------------------ ----------- ------------------------------
control_management_pack_access string      DIAGNOSTIC+TUNING

SQL> SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;

  COUNT(*)
----------
     12245

SQL> ALTER SYSTEM SET control_management_pack_access=NONE;

System altered.

SQL>  SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;

  COUNT(*)
----------
         0
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google