Check oracle DBA_FEATURE_USAGE_STATISTICS script
================================================
Check oracle DBA_FEATURE_USAGE_STATISTICS script
================================================
SELECT
NAME ,
VERSION ,
DETECTED_USAGES ,
CURRENTLY_USED ,
FIRST_USAGE_DATE ,
LAST_USAGE_DATE ,
LAST_SAMPLE_DATE ,
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%' AND name NOT LIKE '%HeapCompression%') -- (#46352) - Ignore HeapCompression in dba fus)
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%' AND name NOT LIKE 'Automatic SQL Tuning Advisor') -- (#46989) - Ignore Automatic SQL Tuning Advisor in DBA FUS
OR name LIKE '%SQL Access Advisor%'
OR name LIKE '%Vault%')
ORDER BY name;
Comments
Post a Comment