VIEW: SYS.DBA_FEATURE_USAGE_STATISTICS

Source

View Text - Preformatted

select samp.dbid, fu.name, samp.version, detected_usages, total_samples,
  decode(to_char(last_usage_date, 'MM/DD/YYYY, HH:MI:SS'),
         NULL, 'FALSE',
         to_char(last_sample_date, 'MM/DD/YYYY, HH:MI:SS'), 'TRUE',
         'FALSE')
  currently_used, first_usage_date, last_usage_date, aux_count,
  feature_info, last_sample_date, last_sample_period,
  sample_interval, mt.description
 from wri$_dbu_usage_sample samp, wri$_dbu_feature_usage fu,
      wri$_dbu_feature_metadata mt
 where
  samp.dbid    = fu.dbid and
  samp.version = fu.version and
  fu.name      = mt.name and
  fu.name not like '_DBFUS_TEST%' and   /* filter out test features */
  bitand(mt.usg_det_method, 4) != 4     /* filter out disabled features */

View Text - HTML Formatted

SELECT SAMP.DBID
, FU.NAME
, SAMP.VERSION
, DETECTED_USAGES
, TOTAL_SAMPLES
, DECODE(TO_CHAR(LAST_USAGE_DATE
, 'MM/DD/YYYY
, HH:MI:SS')
, NULL
, 'FALSE'
, TO_CHAR(LAST_SAMPLE_DATE
, 'MM/DD/YYYY
, HH:MI:SS')
, 'TRUE'
, 'FALSE') CURRENTLY_USED
, FIRST_USAGE_DATE
, LAST_USAGE_DATE
, AUX_COUNT
, FEATURE_INFO
, LAST_SAMPLE_DATE
, LAST_SAMPLE_PERIOD
, SAMPLE_INTERVAL
, MT.DESCRIPTION
FROM WRI$_DBU_USAGE_SAMPLE SAMP
, WRI$_DBU_FEATURE_USAGE FU
, WRI$_DBU_FEATURE_METADATA MT WHERE SAMP.DBID = FU.DBID AND SAMP.VERSION = FU.VERSION AND FU.NAME = MT.NAME AND FU.NAME NOT LIKE '_DBFUS_TEST%'
AND /* FILTER OUT TEST FEATURES */ BITAND(MT.USG_DET_METHOD
, 4) != 4 /* FILTER OUT DISABLED FEATURES */