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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer