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

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Website Stats