Cacher is the code snippet organizer for pro developers

col name format a45 wor wra
col version format a10
col detected_usages format 9999
set lines 80
set pages 1000
select name, version, detected_usages
  from dba_feature_usage_statistics
 where detected_usages!=0
 order by 1;

select NAME, CURRENTLY_USED, LAST_USAGE_DATE from DBA_FEATURE_USAGE_STATISTICS order by 1;

select NAME, CURRENTLY_USED, FIRST_USAGE_DATE from DBA_FEATURE_USAGE_STATISTICS order by 1;