Useful query to find out Oracle Licensing Option usage
Below SQL statement is useful to comply Oracle licensing. It also as a useful tools to check whether specific option has been used before it can be safely removed/deinstalled. SQL> desc DBA_FEATURE_USAGE_STATISTICS Name Null? Type —————————————– ——– —————– DBID NOT NULL NUMBER NAME NOT NULL VARCHAR2(64) VERSION NOT NULL VARCHAR2(17) DETECTED_USAGES NOT NULL NUMBER TOTAL_SAMPLES NOT NULL NUMBER CURRENTLY_USED VARCHAR2(5) FIRST_USAGE_DATE DATE LAST_USAGE_DATE DATE AUX_COUNT NUMBER FEATURE_INFO CLOB LAST_SAMPLE_DATE DATE LAST_SAMPLE_PERIOD NUMBER SAMPLE_INTERVAL NUMBER DESCRIPTION VARCHAR2(128) SQL> select name,last_usage_date from dba_feature_usage_statistics where detected_usages>0 order by 1; NAME LAST_USAG ——————————————————- ——— Audit Options 23-SEP-09 Automatic Maintenance – Optimizer Statistics Gathering...