To check Tuning and diagnostic pack in oracle database

show parameter control

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

DIAGNOSTIC+TUNING: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.

DIAGNOSTIC: Only Diagnostic Pack functionality is enabled in the server.

NONE: Diagnostic Pack and Tuning pack functionally is disabled in the database server.