Топ-100
 
CerebroSQL

Oracle feature usage

Information about statistics on the use of database functions

Oracle feature usage.jpg

-> Request to retrieve data <-

SELECT name,
       detected_usages detected,
       total_samples  samples,
       currently_used  used,
       to_char(last_sample_date, 'DD-MM-YYYY HH24:MI') last_sample,
       sample_interval interval
  FROM dba_feature_usage_statistics
where version = (select version from v$instance)
order by currently_used desc, name

-----