Enable/Disable "Oracle Diagnostic and Tuning Packe"

CONTROL_MANAGEMENT_PACK_ACCESS parameter allows you to control which packs are utilized.

This parameter takes below values

• NONE – Neither pack is available.

• DIAGNOSTIC – To enable only Diagnostic pack.

• DIAGNOSTIC+TUNING – Both packs are available. This is the default.

How to check:

SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS

NAME				     TYPE	 VALUE

------------------------------------ ----------- ------------------------------

control_management_pack_access	     string	 DIAGNOSTIC+TUNING

SQL>

Enable

ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS= "DIAGNOSTIC+TUNING" SCOPE=BOTH;

Disable

ALTER SYSTEM SET control_management_pack_access='NONE' SCOPE=BOTH;