How do I check if the Oracle options/packs are used?

Usage Statistics of the Oracle options/packs.

 

Step 1:

connect to support.oracle.com

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

download the options_packs_usage_statistics.sql script

Step 2:

How to generate the Database Options/Management Packs Reports?

sqlplus -s <UserName/Password> @options_packs_usage_statistics.sql

Step 3:

sample report

 

See Also: