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.
