Oracle application management suite licensing

This Licensing Information document is a part of the product or program documentation under the terms of your Oracle license agreement and is intended to help you understand the program editions, entitlements, restrictions, prerequisites, special license rights, and/or separately licensed third party technology terms associated with the Oracle software program(s) covered by this document (the "Program(s)"). Entitled or restricted use products or components identified in this document that are not provided with the particular Program may be obtained from the Oracle Software Delivery Cloud website ( https://edelivery.oracle.com ) or from media Oracle may provide. If you have a question about your license rights and obligations, please contact your Oracle sales representative, review the information provided in Oracle’s Software Investment Guide ( http://www.oracle.com/us/corporate/pricing/software-investment-guide/index.html ), and/or contact the applicable Oracle License Management Services representative listed on http://www.oracle.com/us/corporate/license-management-services/index.html .

1.2 Oracle Database Offerings

Table 1-1 Oracle Database Offerings

Oracle Database Standard Edition 2

On-Premises, OCI*, and ACEs**

Oracle Database Standard Edition 2 includes features necessary to develop workgroup, department-level, and Web applications.

Oracle Database Enterprise Edition

On-Premises, OCI*, and ACEs**

Oracle Database Enterprise Edition provides performance, availability, scalability, and security for developing applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications.

Oracle Database Enterprise Edition can be enhanced with the purchase of Oracle Database options and Oracle management packs.

Oracle Database Enterprise Edition on Engineered Systems

On-Premises, OCI*, and ACEs**

Oracle Database Enterprise Edition software installed on an engineered system (Oracle Exadata Database Machine or Oracle Database Appliance).

Includes all of the components of Oracle Database. You can further enhance this offering with the purchase of Oracle Database options and Oracle management packs.

The licensing policies for EE-ES vary depending on whether it is installed on Oracle Exadata Database Machine or Oracle Database Appliance. Be sure to make note of these differences, which are documented in the subsequent sections of this guide.

Oracle Database Personal Edition

Oracle Database Personal Edition supports single-user development and deployment environments that require full compatibility with Oracle Database Standard Edition 2 and Oracle Database Enterprise Edition.

Includes all of the components that are included with Enterprise Edition, as well as all Oracle Database options, with the exception of the Oracle RAC One Node and Oracle Real Application Clusters options, which cannot be used with Personal Edition. Personal Edition is available on Linux and Windows platforms only. Oracle management packs cannot be used with Personal Edition.

Oracle Base Database Service Standard Edition

Includes Oracle Database Standard Edition 2 software

Oracle Base Database Service Enterprise Edition

Includes Oracle Database Enterprise Edition software

Oracle Base Database Service Enterprise Edition - High Performance

Includes Oracle Base Database Service Enterprise Edition software plus many Oracle Database options and Oracle management packs

Oracle Base Database Service Enterprise Edition - Extreme Performance

Includes Oracle Base Database Service Enterprise Edition software plus all Oracle Database options and Oracle management packs that are appropriate for use in the cloud.

Oracle Exadata Database Service on Dedicated Infrastructure

Oracle Exadata Database Service on Cloud@Customer

This guide uses ExaDB to describe the licensing policies for both Oracle Exadata Database Service on Dedicated Infrastructure and Oracle Exadata Database Service on Cloud@Customer.

These offerings include Oracle Database Enterprise Edition software plus all Oracle Database options and Oracle management packs that are appropriate for use in Oracle Exadata Database Service on Dedicated Infrastructure or Oracle Exadata Database Service on Cloud@Customer.

* OCI: Oracle Cloud Infrastructure

**ACEs: Authorized Cloud Environments

For the list of Authorized Cloud Environments, see https://www.oracle.com/assets/cloud-licensing-070579.pdf . All other public clouds and environments that are in any way considered an extension of non-Authorized Cloud Environments, such as cloud management, cloud billing, cloud support, cloud automation, cloud images, or cloud monitoring software, are not Authorized Cloud Environments.

1.3 Permitted Features, Options, and Management Packs by Oracle Database Offering

The tables in this section list Oracle Database features, Oracle Database options, and Oracle management packs, and their availability for each Oracle Database offering. The Y value in a column means that the feature, option, or pack is available for a particular offering; N means that it is unavailable; N/A means that it is not applicable. These tables can help you understand the difference between Oracle Database offerings to determine which one is right for you.

The tables are organized into the following functional categories:

Table 1-2 Consolidation

Oracle Multitenant - # of PDBs

The number value in each column indicates the maximum number of pluggable databases (PDBs) that can be created for each offering.

Authorized Cloud Environments: Use is limited to three pluggable databases per container database.

Note: For licensing purposes, one non-CDB instance is equivalent to one user-created PDB inside one CDB.

CDB Fleet Management

PDB Snapshot Carousel

Refreshable PDB switchover

Table 1-3 Development Platform

Requires Oracle Programmer

Oracle Developer Tools for Visual Studio

Microsoft Distributed Transaction Coordinator support

Native .NET Data Provider—ODP.NET

.NET Stored Procedures

Table 1-4 High Availability

EE and EE-ES : Requires the Oracle Active Data Guard option, the Oracle RAC One Node option, or the Oracle Real Application Clusters option

EE and EE-ES : No limit on the number of either primary shards or standby shards if every shard has an Oracle Active Data Guard, Oracle GoldenGate, or Oracle RAC license. Without an Oracle Active Data Guard, Oracle GoldenGate, or Oracle RAC license, use is limited to three primary shards, with basic Data Guard standbys.

BaseDB EE , BaseDB EE-HP , and Authorized Cloud Environments : Use is limited to three primary shards; there is no limit on the number of standby shards.

BaseDB EE-EP and ExaDB : No limit on the number of either primary shards or standby shards.

Oracle Fail Safe

Oracle RAC One Node

EE and EE-ES : Extra cost option

Standard Edition High Availability

Enterprise Edition High Availability

EE-ES : Available on Oracle Database Appliance. Not available on Exadata.

Oracle Data Guard—Redo Apply

Oracle Data Guard—Far Sync Standby

EE and EE-ES : Requires the Oracle Active Data Guard option

Oracle Data Guard—SQL Apply

Oracle Data Guard—Snapshot Standby

Oracle Data Guard—Real-Time Cascading Standbys

EE and EE-ES : Requires the Oracle Active Data Guard option

Oracle Data Guard—Automatic Correction of Non-logged Blocks at a Data Guard Standby Database

EE-ES : Requires the Oracle Active Data Guard option

Oracle Active Data Guard

EE and EE-ES : Extra cost option

CLOUD : Active Data Guard DML Redirection is only available in OCI

Rolling Upgrades—Patch Set, Database, and Operating System

Rolling Upgrade Using Active Data Guard

EE and EE-ES : Requires the Oracle Active Data Guard option

Online index rebuild

Online table organization

ALTER TABLE . MOVE ONLINE operations

Online table redefinition

Using the DBMS_REDEFINITION package

Duplexed backup sets

Block change tracking for fast incremental backup

Unused block compression in backups

Block-level media recovery

Lost Write Protection

Automatic Block Repair

EE and EE-ES : Requires the Oracle Active Data Guard option

Parallel backup and recovery

Tablespace point-in-time recovery

Fast-start fault recovery

Flashback Transaction Query

Optimization for Flashback Time Travel

(formerly Optimization for Flashback Data Archive)

Basic Flashback Time Travel is in all offerings

EE and EE-ES : Optimization for Flashback Time Travel requires the Oracle Advanced Compression option

Online Datafile Move

Cross-platform Backup and Recovery

Global Data Services

EE and EE-ES : Requires the Oracle Active Data Guard option

Recovering tables and table partitions from RMAN backups

Table 1-5 Integration

Includes Database Gateway for ODBC

All other Database Gateway products require a separate product license

AQ Sharded Queues

Includes a restricted use license for Oracle Partitioning. Refer to AQ Sharded Queues in "Restricted Use Licenses" for more information.

Table 1-6 Manageability

Oracle Cloud Management Pack for Oracle Database

EE and EE-ES : Extra cost option

Oracle Data Masking and Subsetting Pack

EE and EE-ES : Extra cost option

Oracle Database Lifecycle Management Pack for Oracle Database

EE and EE-ES : Extra cost option

Oracle Diagnostics Pack

EE and EE-ES : Extra cost option

Oracle Tuning Pack

EE and EE-ES : Extra cost option, also requires Oracle Diagnostics Pack

Oracle Real Application Testing

EE and EE-ES : Extra cost option

Database Resource Manager

I/O Resource Management

SQL Plan Management

SQL Plan Management does not require a license for Oracle Diagnostics Pack or Oracle Tuning Pack

SE2 and BaseDB SE Summary: Only one SQL plan baseline per SQL statement is allowed and SQL plan evolution is disabled.

SE2 and BaseDB SE Details:

  1. SQL plan baselines can be created or captured using the following methods:
  2. All capture and creation methods store only one SQL plan baseline per SQL statement.
  3. SQL plan baselines can be exported and imported using DBMS_SPM.CREATE_STGTAB_BASELINE , DBMS_SPM.PACK_STGTAB_BASELINE , and DBMS_SPM.UNPACK_STGTAB_BASELINE .
  4. Unused SQL plan baselines are not auto-purged.
  5. Alternative SQL execution plans for SQL statements are not added to the SQL plan history.
  6. SQL plan baselines can be altered and dropped ( DBMS_SPM.ALTER_SQL_PLAN_BASELINE and DBMS_SPM.DROP_SQL_PLAN_BASELINE ).
  7. The following DBMS_SPM functions and procedures are not allowed: CONFIGURE , LOAD_PLANS_FROM_AWR , LOAD_PLANS_FROM_SQLSET , and all functions and procedures associated with SQL plan evolution.

Automatic SQL Plan Management

Note: The licensing policy shown here applies to this feature starting with Oracle Database 19c, Release Update 19.22. In earlier versions of Oracle Database 19c, this feature is available only on Exadata on-premises systems and ExaDB.

SQL Tuning Sets

EE and EE-ES : SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. Usage of any subprograms in the DBMS_SQLSET package to manage SQL Tuning Sets is part of the EE and EE-ES offerings. In addition, the following subprograms, part of the DBMS_SQLTUNE package, provide an older interface to manage SQL Tuning Sets and are also part of the EE and EE-ES offerings: ADD_SQLSET_REFERENCE , CAPTURE_CURSOR_CACHE_SQLSET , CREATE_SQLSET , CREATE_STGTAB_SQLSET , DELETE_SQLSET , DROP_SQLSET , LOAD_SQLSET , PACK_STGTAB_SQLSET , REMOVE_SQLSET_REFERENCE , SELECT_CURSOR_CACHE , SELECT_SQLSET , SELECT_WORKLOAD_REPOSITORY , UNPACK_STGTAB_SQLSET , UPDATE_SQLSET .

Oracle Fleet Patching and Provisioning

(formerly Rapid Home Provisioning)

EE and EE-ES : When deployed across multiple clusters, each FPP-managed target must be licensed for one of the following: Oracle Database Lifecycle Management Pack, Oracle RAC, or Oracle RAC One Node

Table 1-7 Networking

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

Oracle Connection Manager

Available via a custom install of the Oracle Database client, usually installed on a separate machine or compute instance

EE and EE-ES : Requires the Oracle Advanced Compression option

Table 1-8 Performance

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

High-Frequency Automatic Optimizer Statistics Collection

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

Client Side Query Cache

Query Results Cache

PL/SQL Function Result Cache

Oracle TimesTen Application-Tier Database Cache

EE and EE-ES : Extra cost option

Database Smart Flash Cache

EE : Solaris and Oracle Linux only

EE-ES : Available on Oracle Database Appliance. Not available on Exadata

Support for Oracle Exadata Storage Server Software

EE-ES : Available on Exadata. Not available on Oracle Database Appliance.

Adaptive Execution Plans

Concurrent Execution of UNION and UNION ALL Branches

Oracle Database In-Memory

EE and EE-ES : Extra cost option

In-Memory Column Cache on Storage Servers

EE-ES : Available on Exadata and requires the Oracle Database In-Memory option. Not available on Oracle Database Appliance.

Requires Exadata or Supercluster

In-Memory Column Store on Active Data Guard standby

EE-ES : Available on Exadata and requires the Oracle Database In-Memory option and the Oracle Active Data Guard option. Not available on Oracle Database Appliance.

Fault Tolerant In-Memory Column Store

EE-ES : Available on Exadata and Oracle Database Appliance. Requires the Oracle Database In-Memory option and the Oracle Real Application Clusters option.

Requires Exadata, Supercluster, or Infiniband-based Oracle Database Appliance

EE and EE-ES : Requires the Oracle Database In-Memory option

In-Memory Column Store support for External Tables

EE and EE-ES : Requires the Oracle Database In-Memory option

Note: The licensing policy shown here applies to this feature starting with Oracle Database 19c, Release Update 19.12. In earlier versions of Oracle Database 19c, this feature is available only on Exadata on-premises systems (requires the Oracle Database In-Memory option) and ExaDB.

EE and EE-ES : Requires the Oracle Database In-Memory option

Database In-Memory Base Level

Allows you to experiment with Oracle Database In-Memory features without purchasing the Oracle Database In-Memory option. The following restrictions apply:

CLOUD : Only available in OCI

Note: The licensing policy shown here applies to this feature starting with Oracle Database 19c, Release Update 19.12. In earlier versions of Oracle Database 19c, this feature is available only on Exadata on-premises systems and ExaDB.

EE-ES : Available on Exadata and requires the Oracle Partitioning option. Not available on Oracle Database Appliance.

Table 1-9 Scalability

Oracle Real Application Clusters (Oracle RAC)

EE and EE-ES : Extra cost option

Automatic Workload Management

EE and EE-ES : Requires the Oracle Real Application Clusters option

Quality of Service Management

EE and EE-ES : Requires the Oracle RAC One Node option or the Oracle Real Application Clusters option

Oracle NoSQL Database Enterprise Edition

Table 1-10 Security

Transparent Data Encryption (TDE) for Columns

EE and EE-ES : Requires the Oracle Advanced Security option

Transparent Data Encryption (TDE) for Tablespaces

EE and EE-ES : Requires the Oracle Advanced Security option

Oracle Advanced Security

EE and EE-ES : Extra cost option

Oracle Database Vault

EE and EE-ES : Extra cost option

Oracle Label Security

EE and EE-ES : Extra cost option

Enterprise User Security

EE , EE-ES , BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , and ExaDB : Enterprise User Security is a feature for directory-based management of database users. It requires a corresponding Oracle Identity Management Directory Services Plus to be licensed.

Centrally Managed Users

EE , EE-ES , BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , and ExaDB : Centrally Managed Users is a feature for centrally authenticating and authorizing database users with Microsoft Active Directory.

Real Application Security

EE and EE-ES : Requires the Oracle Advanced Security option

Transparent Sensitive Data Protection

Virtual Private Database

Keystore for Each Pluggable Database

EE : This feature is available starting with Oracle Database release 19c, Release Update 19.14, and requires the Oracle Advanced Security option.

EE-ES : Requires the Oracle Advanced Security option

CLOUD : Only available in OCI

Table 1-11 Snapshots and Cloning

Storage Snapshot Optimization

EE and EE-ES : Requires the Oracle Advanced Compression option

Table 1-12 Spatial and Graph Data

Oracle Spatial and Graph

Oracle Spatial and Graph no longer requires an extra cost license. See Oracle Database Insider blog post for more information.

Property Graph and RDF Graph Technologies (RDF/OWL)

Property Graph and RDF Graph Technologies (RDF/OWL) no longer requires an extra cost license. See Oracle Database Insider blog post for more information.

Parallel spatial index builds

Partitioned spatial indexes

EE and EE-ES : Requires the Oracle Partitioning option

Table 1-13 VLDB, Data Warehousing, and Business Intelligence

EE and EE-ES : Extra cost option

Oracle On-Line Analytical Processing (OLAP)

EE and EE-ES : Extra cost option

Oracle Machine Learning (formerly Advanced Analytics)

Oracle Machine Learning no longer requires an extra cost license. See Oracle Database Insider blog post for more information.

Oracle Advanced Compression

EE and EE-ES : Extra cost option

Advanced Index Compression

EE and EE-ES : Requires the Oracle Advanced Compression option

Prefix Compression (also called Key Compression)

Hybrid Columnar Compression

EE : Requires ZFS, Axiom, or FS1 storage

Row-Level Locking for Hybrid Columnar Compression

EE : Requires ZFS or FS1 storage, and the Oracle Advanced Compression option

EE-ES : Requires the Oracle Advanced Compression option

Exadata Flash Cache Compression

EE-ES : Available on Exadata and requires the Oracle Advanced Compression option. Not available on Oracle Database Appliance.

Automatic Data Optimization

EE and EE-ES : Requires the Oracle Advanced Compression option or the Oracle Database In-Memory option

Basic Table Compression

Deferred Segment Creation

Bitmapped index, bitmapped join index, and bitmap plan conversions

Parallel statistics gathering

Parallel index build/scans

Parallel Data Pump Export/Import

In-memory Parallel Execution

Parallel Statement Queuing

Parallel capture and apply via XStream

Transportable tablespaces, including cross-platform and full transportable export and import

Import of transportable tablespaces is supported from all offerings that include Enterprise Edition software into SE2 ; this does not include the use of cross-platform capabilities.

Summary management—Materialized View Query Rewrite

1.4 Oracle Database Options and Their Permitted Features

Table 1-14 lists Oracle Database options, the Oracle Database offerings for which each option is available, and the features that are included with each option. You must be licensed for an option in order to use any of its features.

Table 1-14 Oracle Database Options and Their Permitted Features

Oracle Active Data Guard

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-EP , ExaDB

Oracle Active Data Guard includes the following features:

In an Oracle Data Guard configuration:

Oracle Advanced Compression

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Advanced Compression includes the following features:

Oracle Advanced Security

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Advanced Security includes the following features:

Oracle Advanced Security includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Advanced Security in "Restricted Use Licenses" for more information.

Note: Network encryption (native network encryption, network data integrity, and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of Oracle Database.

Oracle Database In-Memory

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-EP , ExaDB

Oracle Database In-Memory includes the following features:

Oracle Database Vault

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Database Vault includes the following features:

In an Oracle Multitenant environment, an Oracle Database Vault license is required when Oracle Database Vault is enabled in the CDB root, regardless of whether any PDBs are plugged in to the CDB root. An Oracle Database Vault license is not required when Oracle Database Vault is merely installed or configured in the CDB root. The Oracle Database Vault license applies to the entire CDB; you cannot license individual PDBs.

When you purchase a license to use Oracle Database Vault on Oracle Database Enterprise Edition ( EE or EE-ES ), the licensing metrics for Oracle Database Vault must match the licensing metrics for Oracle Database Enterprise Edition.

Oracle Database Vault includes special license rights for Oracle Label Security. Refer to Oracle Database Vault in "Special License Rights" for more information.

Oracle Database Vault includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Database Vault in "Restricted Use Licenses" for more information.

Oracle Label Security

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Label Security includes the following features:

In an Oracle Multitenant environment, an Oracle Label Security license is required when an Oracle Label Security policy is created in any container. An Oracle Label Security license is not required when Oracle Label Security is merely installed or enabled in any container. The Oracle Label Security license applies to the entire CDB; you cannot license individual PDBs.

When you purchase a license to use Oracle Label Security on Oracle Database Enterprise Edition ( EE or EE-ES ), the licensing metrics for Oracle Label Security must match the licensing metrics for Oracle Database Enterprise Edition.

Oracle Label Security includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Label Security in "Restricted Use Licenses" for more information.

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Multitenant includes the following features:

Note: For licensing purposes, one non-CDB instance is equivalent to one user-created PDB inside one CDB.

Oracle On-Line Analytical Processing (OLAP)

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle On-Line Analytical Processing (OLAP) includes the following features:

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

These are some of the features that make use of Oracle Partitioning:

Oracle RAC One Node

Extra cost option: EE , EE-ES

Oracle RAC One Node includes the following features:

Oracle Real Application Clusters (Oracle RAC)

Extra cost option: EE , EE-ES

Included option: BaseDB EE-EP , ExaDB

Oracle Real Application Clusters (Oracle RAC) includes the following features:

Oracle Real Application Testing

Extra cost option: EE , EE-ES

Included option: PE , BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , ExaDB

Oracle Real Application Testing includes the following features:

SQL Performance Analyzer (SPA)

An Oracle Real Application Testing license permits you to access SQL Performance Analyzer functionality through Oracle Enterprise Manager, as well as through the following database server command-line API: DBMS_SQLPA package, which is part of the Oracle Real Application Testing option.

Database Migration Planner