For Oracle license info

                              Oracle license Info

Oracle product Info 

 

 

col DESCRIPTION format a30 
col name format a20
SELECT
DBID ,NAME ,VERSION ,DETECTED_USAGES ,TOTAL_SAMPLES ,CURRENTLY_USED ,FIRST_USAGE_DATE ,LAST_USAGE_DATE ,
-- LAST_SAMPLE_DATE ,LAST_SAMPLE_PERIOD ,
--SAMPLE_INTERVAL ,
DESCRIPTION          
from DBA_FEATURE_USAGE_STATISTICS
where  detected_usages > 0 and
( name like '%ADDM%'
or name like '%Automatic Database Diagnostic Monitor%'
or name like '%Automatic Workload Repository%'
or name like '%AWR%' 
or name like '%Baseline%'
or name like '%Compression%'
or name like '%Data Guard%'
or name like '%Data Mining%'
or name like '%Database Replay%'
or name like '%EM%'
or name like '%Encrypt%'
or name like '%Exadata%' 
or name like '%Flashback Data Archive%'
or name like '%Label Security%'
or name like '%OLAP%'
or name like '%Pack%'
or name like '%Partitioning%' 
or name like '%Real Application Clusters%'
or name like '%SecureFile%'
or name like '%Spatial%'
or name like '%SQL Monitoring%'
or name like '%SQL Performance%'
or name like '%SQL Profile%'
or name like '%SQL Tuning%' 
or name like '%SQL Access Advisor%' 
or name like '%Vault%')
and  CURRENTLY_USED='TRUE'  ---------------------<<<<<<<<<<<<<<<<<<<<<<<
order by name;

 

 

      DBID NAME                 VERSION           DETECTED_USAGES TOTAL_SAMPLES CURRE FIRST_USA LAST_USAG DESCRIPTION
---------- -------------------- ----------------- --------------- ------------- ----- --------- --------- ------------------------------
1267852645 Automatic Maintenanc 11.2.0.1.0                     40            40 TRUE  10-JAN-11 16-NOV-11 Automatic initiation of SQL Tu
           e - SQL Tuning Advis                                                                           ning Advisor
           or

1267852645 Automatic SQL Tuning 11.2.0.1.0                     39            40 TRUE  18-JAN-11 16-NOV-11 Automatic SQL Tuning Advisor h
            Advisor                                                                                       as been used.

1267852645 Backup BASIC Compres 11.2.0.1.0                      9            40 TRUE  28-JUL-11 16-NOV-11 BASIC compressed backups are b
           sion                                                                                           eing used.

1267852645 Partitioning (system 11.2.0.1.0                     40            40 TRUE  10-JAN-11 16-NOV-11 Oracle Partitioning option is
           )                                                                                              being used - there is at least
                                                                                                           one partitioned object create
                                                                                                          d.

1267852645 Partitioning (user)  11.2.0.1.0                      8            40 TRUE  29-SEP-11 16-NOV-11 Oracle Partitioning option is
                                                                                                          being used - there is at least
                                                                                                           one user partitioned object c
                                                                                                          reated.

1267852645 SQL Profile          11.2.0.1.0                      5            40 TRUE  20-OCT-11 16-NOV-11 SQL profiles have been used.
1267852645 SQL Tuning Set (syst 11.2.0.1.0                     21            40 TRUE  30-JUN-11 16-NOV-11 A SQL Tuning Set has been crea
           em)                                                                                            ted in the database in the SYS
                                                                                                           schema.

1267852645 SecureFiles (system) 11.2.0.1.0                     40            40 TRUE  10-JAN-11 16-NOV-11 SecureFiles is being used by s
                                                                                                          ystem users

1267852645 Transparent Data Enc 11.2.0.1.0                      8            40 TRUE  29-SEP-11 16-NOV-11 Transparent Database Encryptio
           ryption                                                                                        n is being used. There is atle
                                                                                                          ast one column or tablespace t
                                                                                                          hat is encrypted.


9 rows selected.