How to check if your Oracle Database is licensed with DIAGNOSTIC+TUNING pack ?

For many advanced SQL monitoring and tuning features within Oracle Database, Oracle Corp. required the customers to have DIAGNOSTIC+TUNING management packs. Below sql will help you to identify if the database own the licenses.

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

You will see VALUE column as 'DIAGNOSTIC+TUNING'.