How to detect used features in oracle?

DBA_FEATURE_USAGE_STATISTICS:-
displays information about what features are being used in database.

This view dba_feature_usage_statistics updates at a regular interval of seven days (default behavior) with what features have been used in the database.

We can manually refresh this view by executing below statement:-

EXEC DBMS_FEATURE_USAGE_INTERNAL.exec_db_usage_sampling(SYSDATE);

dba_feature_usage_statistics description:-



SELECT name Feature,
  version,
  detected_usages,
  TO_CHAR(first_usage_date,'DD-MON-YYYY') first_used,
  TO_CHAR(last_usage_date,'DD-MON-YYYY') last_used,
  currently_used
FROM dba_feature_usage_statistics
WHERE first_usage_date IS NOT NULL;

Expected Output:-