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

 Database Options/Management Packs Usage Report

You can determine whether an option is currently in use in a database by running options_packs_usage_statistics.sql, which replaces both former scripts option_usage.sql and used_options_details.sql.
You can manually run options_packs_usage_statistics.sql in an individual database or use Oracle Enterprise Manager Job System to automatically run options_packs_usage_statistics.sql on multiple databases.

For Container Databases (CDB):
 - when connected to CDB$ROOT container, the script lists data for all the open PDBs, properly detecting if Multitenant Option licensing is needed.
 - when connected to a PDB, the script lists only local data,  as there is no visibility to other PDBs, due to the isolation  provided by the Multitenant Architecture. For the same reason,  Multitenant Option usage (more than one PDB) cannot be detected.

Description

The report is divided into two main sections PRODUCT USAGE and FEATURE USAGE DETAILS which reports overview and detailed information for Database Options/Management Packs usage for Oracle Databases for 11.2 and later. You need the "SELECT ANY DICTIONARY" privilege to execute the script.
The report is based on the DBA_FEATURE_USAGE_STATISTICS view. Note that the feature usage data in the view is updated once a week, so it may take up to 7 days for the report to show recent usage of options and/or packs.
The output can be easily opened in a spreadsheet, if needed.

Please review the Description & Disclaimer section in the script before executing the script.

Kindly note the report generated is to be used for informational purposes only and this does not represent your license entitlement or requirement. for known issues with this check MOS DOC ID 1309070.1

 
PRODUCT USAGE

Description

This section provides an overview of each option/pack that has been used in the database and if they are currently in use. It will also provide information when the product was first used and when it was used last time.

FEATURE USAGE DETAILS

Description

This section provides a detailed report of features used that has triggered the usage of a product.
The report is based on the DBA_FEATURE_USAGE_STATISTICS view.
The CURRENTLY_USED column of DBA_FEATURE_USAGE_STATISTICS view  indicates if the feature in question was used during the last sampling interval by VERSION and DBID

 

Click here to download the options_packs_usage_statistics.sql script

How to generate the Database Options/Management Packs Reports?

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

 

Who to contact for more information?

For any technical issues with this report or scripts or output of dba_feature_usage_statistics please create a service request.

Oracle Technology Prerequisites Rules for Oracle E-Business Suite Applications

This section provides an overview of Oracle’s licensing prerequisites for the underlying database and

other technologies when license Oracle E-Business Suite Applications as it relates to the level of

modifications that are performed to the application programs. Additional prerequisites may apply to

specific application programs, please contact your Oracle sales representative for more information.

Please note that there are two tables: one table applicable for orders after February 28, 2007 (see

pages 3 and 4); and one table applicable for orders up to and including February 28, 2007 (see pages

5 and 6).

Oracle distinguishes between three levels of modifications to its Oracle E-Business Suite Applications,

which have increasing licensing requirements for the underlying database and other technologies.

These modification levels are:

No Modifications: The customer is deploying the application without modifications. In this case, the

customer receives a restricted-use license for the Oracle Database Enterprise Edition, Oracle Internet

Application Server Enterprise Edition, which includes WebLogic Server Basic, and a limited set of

other products. This restricted-use license may only be used to run with the licensed application(s); it

cannot be used for any other purposes.

Modifications implemented as Java programs and/or modifications to Forms, Reports and/or

Workbooks: These modifications include any creation or modification of reports, forms, and/or

workbooks. In addition, modifications implemented as Java programs, which include Java that

produces html interface or Java business logic fall under this category. In these two scenarios, the

customer receives a restricted-use license for the Oracle Database Enterprise Edition and a limited

set of other products. This restricted-use license may only be used to run with the licensed

application(s); it cannot be used for any other purposes. Additionally, the customer is required to

purchase licenses for a limited set of products, including Oracle Internet Application Server Enterprise

Edition for the total number of end users1 or processors for which the modifications are deployed.

Modifications to the database: Examples of these modifications include adding and/or modifying the

tables, columns, stored procedures and triggers, which are the part of Oracle E-Business Suite

application schema. In this situation, the customer is required to purchase licenses for the Oracle

Database Enterprise Edition, as well as Oracle Internet Application Server Enterprise Edition for the

total number of end users1 or processors for which the modifications are deployed. The customer

receives a restricted-use license of a limited set of products. Additionally, a limited set of other

products is required to be licensed as defined in the following table

https://www.oracle.com/us/corporate/pricing/application-licensing-table-070571.pdf