Oracle DBA – A lifelong learning experience

  • Meta

  • Categories

  • Blog Stats

    • 1,634,354 hits
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 376 other followers

Posts Tagged ‘control_management_pack_access’

Disabling ADDM in 10g and 11g

Posted by John Hallas on January 17, 2009

You may not be licensed to use ADDM and want to stop automatic statistics collection, which is enabled by default.

The method alters from 10g to 11g


Use the package to modify the snapshot interval to 0

Execute dbms_workload_repository.modify_snapshot_settings
(retention=>20160, interval=> 0);


The initialization parameter should be set to DIAGNOSTIC+TUNING (default) or DIAGNOSTIC to enable automatic database diagnostic monitoring. Setting CONTROL_MANAGEMENT_PACK_ACCESS to NONE disables many Oracle Database features, including ADDM, and is strongly discouraged, but seems to be the only way to disable the automatic monitoring.

Tuning relies on having a diagnostic license which explains why the options are NONE, DIAGNOSTIC or DIAGNOSTIC+TUNING


Posted in 11g new features, addm, Oracle | Tagged: , , | 3 Comments »