rudydelhaye
2/5/2020 - 9:13 AM

ORCL - Features usage

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;