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

Popular posts from this blog

Shareplex some commands

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

ORA 700 [kskvmstatact: excessive swapping observed]