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> select name,last_usage_date from dba_feature_usage_statistics where detected_usages>0 order by 1;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *