SQL QUERY TO FIND USAGE OF FEATURE FOR LICENSING PURPOSES IN ORACLE
To find if any licensed feature is used in the database or not like AWR or partitioning or OLAP , query dba_feature_usage_statistics
set lines 200 pages 1000
col NAME for a15
col VERSION for a15
col DETECTED_USAGES for 999999
col DESCRIPTION for a20
col FEATURE_INFO for a15
select NAME,
VERSION,
DETECTED_USAGES,
CURRENTLY_USED,
FIRST_USAGE_DATE,
LAST_USAGE_DATE,
DESCRIPTION,
FEATURE_INFO
from dba_feature_usage_statistics
where NAME like '%OLAP%'
or
NAME like '%Part%';
Sample output:
NAME VERSION DETECTED_USAGES CURRE FIRST_USA LAST_USAG DESCRIPTION FEATURE_INFO
--------------- --------------- --------------- ----- --------- --------- -------------------- ---------------
OLAP - Analytic 11.2.0.4.0 0 FALSE OLAP - the analytic
Workspaces workspaces stored in
the database.
SP2-0642: SQL*Plus internal error state 2131, context 0:0:0
Unsafe to proceed
OLAP - Cubes 11.2.0.4.0 0 FALSE OLAP - number of cub
es in the OLAP catal
og that are fully ma
pped and accessible
by the OLAP API.
SP2-0642: SQL*Plus internal error state 2131, context 0:0:0
Unsafe to proceed
Partitioning (s 11.2.0.4.0 22 TRUE 03-APR-21 10-FEB-22 Oracle Partitioning 1:T:RANGE::3::2
ystem) option is being used ::::|1:I:RANGE:
- there is at least :3::2::L