Oracle Database Feature Usage Statistics

Oracle Database includes a powerful internal mechanism called Feature Usage Statistics (FUS), which helps DBAs and system administrators track which features are being used, how often, and by which users or applications.

These statistics provide valuable insights for:

• License compliance and auditing

• Performance tuning and usage optimization

• Capacity planning and upgrade decisions

• Understanding feature adoption trends within your environment

Data is collected in the DBA_FEATURE_USAGE_STATISTICS view and can be queried to monitor:

• Partitioning, Advanced Compression, In-Memory, Data Guard, etc.

• Last usage date and detected usage

• Feature dependencies

You can use the following SQL query to list any specific feature statistics :

SELECT * FROM dba_feature_usage_statistics WHERE name IN ('Automatic Database Diagnostic Monitor');

You can use the following SQL query to lis all feature statistics :

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 name;

You can use the following SQL query to list the database features and their descriptions :

SELECT name, description FROM dba_feature_usage_statistics ORDER BY name;

Tip: Use DBMS_FEATURE_USAGE_REPORT and DBMS_FEATURE_USAGE_INTERNAL packages for detailed reports and internal checks.