rudydelhaye
12/12/2019 - 4:56 PM

ORCL - Check options licensing

set pages 999

col c1 heading 'feature'    format a45
col c2 heading 'times|used' format 999,999
col c3 heading 'first|used'
col c4 heading 'used|now'

select
   name             c1,
   detected_usages  c2,
   first_usage_date c3,
   currently_used   c4
from
   dba_feature_usage_statistics
WHERE name like '%Active%';
set pages 999

col c1 heading 'feature'    format a45
col c2 heading 'times|used' format 999,999
col c3 heading 'first|used'
col c4 heading 'used|now'

select
   name             c1,
   detected_usages  c2,
   first_usage_date c3,
   currently_used   c4
from
   dba_feature_usage_statistics
where
   first_usage_date is not null;