_____________________________________________________________________________________

MANAGEMENT PACKS/TUNING PACKS
=============================
http://stackoverflow.com/questions/21024895/how-can-i-know-if-oracle-diagnostics-pack-and-the-oracle-tuning-pack-are-install

show parameter CONTROL_MANAGEMENT_PACK_ACCESS

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



OPTIONS/FEATURES/COMPONENTS
===========================
col comp_name for a50
col status for a10
select comp_name, status from dba_registry order by 2, 1;

select parameter, value from v$option where parameter like 'Spatial%';

select * from dba_feature_usage_statistics where name = 'Spatial';

select * from dba_registry where comp_name = 'Oracle Database Java Packages';



IS THE DIAGNOSTIC PACK USED?
============================
Do not misleading interpret the USED or LAST SAMPLE DATE column. The point is, that there is a use when DETECTED is more than zero.

col name format a30
col detected format 9999
col samples format 9999
col used format a5
col interval format 9999999
select name,
       detected_usages detected,
                 total_samples   samples,
                 currently_used  used,
                 to_char(last_sample_date,'YYYY-MM-DD:HH24:MI:SS') last_sample,
                 sample_interval interval
from dba_feature_usage_statistics
where name = 'Automatic Workload Repository' order by 1, 5;



USAGE OF THE TUNING PACKS
=========================
col name format a35
col detected format 9999
col samples format 9999
col used format a5
col interval format 9999999

select name,       
       detected_usages detected,
       total_samples   samples,
       currently_used  used,
       to_char(last_sample_date,'YYYY-MM-DD:HH24:MI:SS') last_sample,
       sample_interval interval
  from dba_feature_usage_statistics
 where name    = 'Automatic Workload Repository'
    or name like 'SQL%' order by 1, 5;