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

Leave a Reply