Question: How do I use the
control_management_pack_access parameter to disable the
expensive extra-cost performance pack and tuning packs?
Answer: On 11g and beyond there is
the init.ora parameter:
control_management_pack_access=true, which is used to
disable the OEM Diagnostic Pack and Tuning Packs. For
more information see "Controlling Diagnostic and Tuning Pack
Usage and Disabling AWR" (See MOSC Note 436386.1).