Database Options/Packs Usage Reporting
-- nota descreve como verificar o uso de Oracle Database Options/Management Packs licenciados separadamente
-- DOWNLOAD LINK: https://support.oracle.com/knowledge/Oracle%20Database%20Products/1317265_1.html
options_packs_usage_statistics.sql

-- Alternative ------------------------>
-- Get Features usage:
SELECT u1.name,
       u1.detected_usages,
       u1.currently_used,
       u1.version
FROM   dba_feature_usage_statistics u1
WHERE  u1.version = (select max(u2.version)
                     from   dba_feature_usage_statistics u2
                     where  u2.name = u1.name)
AND    u1.detected_usages > 0
AND    u1.dbid = (select dbid from v$database)
ORDER BY name;

-- Get Options usage:
col parameter for a50
SELECT	parameter,
		value 
FROM V$option
WHERE value='TRUE';

-- Information about Session license limits:
SELECT 	sessions_max s_max,
		sessions_warning s_warning,
		sessions_current s_current,
		sessions_highwater s_high,
		users_max
FROM v$license;

-- Information about CPU license limits:
SELECT 	CPU_COUNT_CURRENT, 
		CPU_CORE_COUNT_CURRENT,
		CPU_SOCKET_COUNT_CURRENT,
		CPU_COUNT_HIGHWATER,
		CPU_CORE_COUNT_HIGHWATER,
		CPU_SOCKET_COUNT_HIGHWATER
FROM V$LICENSE;