To disable diagnostic and tuning pack :

Step 1)

show parameter control;

Step 2)

alter system set control_management_pack_access=none scope=both;

Step 3)

show parameter control;

We can see the disabled diagnostic and tuning pack.

 

In the case of only disable tuning pack , We have to give below command :

Step 4)

alter system set control_management_pack_access=diagnostic scope=both;

 

Then diagnostic will remain same

 

See Also:

• To Disable advanced compression on table partitions
• How to disable OLAP option in Oracle
• http://oracle.com