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: