How to check Oracle feature usage statistics

DBA_FEATURE_USAGE_STATISTICS is Oracle''s own audit of which optional features have been used on this database — the same view Oracle License Management uses in a LMS audit. Shows the latest version row per feature where detected_usages > 0.

COLUMN name            FORMAT a60
COLUMN detected_usages FORMAT 999999999999

SELECT u1.name,
       u1.detected_usages,
       u1.currently_used,
       u1.version
FROM   dba_feature_usage_statistics u1
WHERE  u1.version = (SELECT MAX(u2.version)
                     FROM   dba_feature_usage_statistics u2
                     WHERE  u2.name = u1.name)
AND    u1.detected_usages > 0
AND    u1.dbid = (SELECT dbid FROM v$database)
ORDER BY u1.name;