Check tuning pack is enabled or not

Check tuning pack is enabled or not


select * from v$parameter where name = 'control_management_pack_access';

show parameter control_management_pack_access

The possible values ??are:

NONE – disable all management packs.
DIAGNOSTIC – only DIAGNOSTIC Pack available.
DIAGNOSTIC+TUNING – DIAGNOSTIC and TUNING Pack available.


The value can be changed at runtime.
ALTER SYSTEM SET control_management_pack_access=NONE;