Enable Oracle Diagnostics and Tuning pack

How to enable Diagnostics pack in Oracle Database

This is a licensed feature for Oracle Database. Without the proper licensing, this can not be done.

Parameter Name:  

control_management_pack_access

Steps to be followed:

SQL> show parameter control_management_pack_access

 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access       string      NONE

SQL> ALTER SYSTEM SET control_management_pack_access="DIAGNOSTIC+TUNING";

 

System altered.

 

SQL> show parameter control_management_pack_access

 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access       string      DIAGNOSTIC+TUNING

Note: Before doing that, please make sure you have the corresponding licenses from Oracle.

Best Wishes!!!