Oracle Database is available in the following editions, each suitable for different development and deployment scenarios. Oracle also offers several database options, packs, and other products that enhance the capabilities of Oracle Database for specific purposes. This section describes the Oracle Database editions. The database options and associated products are described in Chapter 2, "Options and Packs".
SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNE package, provide an interface to manage SQL Tuning Sets and are part of Oracle Database Enterprise Edition: 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.
The infrastructure repositories for RMAN, Oracle Enterprise Manager Cloud Control, AWR Warehouse, and Global Data Services Catalog can be shared in one database, or deployed in separate databases. Enterprise Edition must be used for the infrastructure repository database(s).
Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Internet Directory (OID) component of Oracle Directory Services Plus to support enterprise user security.
Oracle Automatic Storage Management or the ASM Cluster File System (ACFS) is required for creating and managing all Oracle database file types. Raw volumes, partitions, or third-party cluster file systems are not supported for storing Oracle database files. Refer to Oracle Automatic Storage Management Administrator's Guide for a comprehensive list of all database file types.
ASM Cluster File System (ACFS) or a local OS file system must be used to store all non-database files. No Oracle-maintained copies of any non-database files can exist in any other locations, with the following exceptions:
Customers who want to manually script maintenance of a standby database can create a second copy of their archive logs outside of Oracle ASM on a local file system only, designated by the LOG_ARCHIVE_DEST_n parameter.
An Oracle Wallet is a PKCS#12 container used to store authentication and encryption keys. The Oracle database secure external password store feature stores passwords in an Oracle Wallet for password-based authentication to the Oracle database. The Oracle Wallet may also be used to store credentials for PKI authentication to the Oracle Database, configuration of network encryption (SSL/TLS), and Oracle Advanced Security transparent data encryption (TDE) master encryption keys. Strong authentication services (Kerberos, PKI, and RADIUS) and network encryption (native network encryption and SSL/TLS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of the Oracle database.
SQL Performance Analyzer: Only the Remote SQL Test Execute and SQL Capture into SQL Tuning Set features are supported. These features can be used only to facilitate upgrades from Oracle9i Database Release 2 and Oracle Database 10g Release 1 to Oracle Database 10g Release 2 or higher. When upgrading to Oracle Database 10g Release 2 from earlier releases (Oracle 9i Database or Oracle Database 10g Release1), Oracle Database 11g is needed to remotely execute SQL on the target database (that is, Oracle Database 10g Release 2). Real Application Testing licensing is required for both systems, Oracle Database 10g Release 2 and Oracle Database 11g.
XStream provides application programming interfaces (APIs) that enable client applications to receive real-time data changes from an Oracle database (using XStream Out APIs) and to send real-time data changes to an Oracle database (using XStream In APIs). These data changes can be shared between Oracle databases and other systems, such as filesystems and non-Oracle databases. XStream is licensed via the Oracle GoldenGate product. You must purchase a license for this product before using the XStream APIs. Please contact your Oracle sales representative for additional information.
A restricted-use license for Oracle HTTP Server is included with all editions (except for Oracle Database Express Edition) when the HTTP Server is running on the same server as the database. Running Oracle HTTP server on a different server requires that other server be licensed to use the HTTP server, either through an Oracle Database license or an Oracle Application Server license.
Oracle Database@Azure will be available in the East US region starting in December 2023. Future expansion is planned globally. Move Oracle databases to the cloud for the highest levels of performance and availability with Oracle database services running on Oracle Cloud Infrastructure deployed in Microsoft Azure.
All service editions include Oracle Transparent Data Encryption, Oracle APEX, Machine Learning, Spatial, and Graph capabilities at no cost, allowing developers to easily add in-database capabilities to existing applications or create new ones.
Implemented their construction ERP service with Base Database Service in Oracle Cloud Infrastructure. They simplified their infrastructure by replacing more than 10 software packages and databases with a single application while achieving dependable, repeatable results.
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.
EE, EE-ES, DBCS EE, DBCS EE-HP, DBCS EE-EP, and ExaCS/CC: 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.
Oracle Active Data Guard must be licensed on any standby databases with any of the above features in use, as well as the primary database. If there are additional standby databases in the Oracle Data Guard configuration that are not using any of the Oracle Active Data Guard features, those standby databases do not require an Oracle Active Data Guard license.
Note: For customers who back up standby databases to Zero Data Loss Recovery Appliance (ZDLRA) and wish to use the Fast Incremental Backup on Physical Standby or Real-Time Cascade feature, an Oracle Active Data Guard license is not required. Oracle Active Data Guard must still be licensed on standby databases, if any other of the above features are in use.
The container root (CDB$Root) of the standby database may be opened read-only without requiring an Oracle Active Data Guard license. An Oracle Active Data Guard license is only required if any of the pluggable databases in the standby is opened for read.
Exadata Flash Cache Compression (This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression.)
An Oracle Real Application Testing license permits you to access Database Replay functionality through Oracle Enterprise Manager, as well as through the following database server command-line APIs: DBMS_WORKLOAD_CAPTURE package and DBMS_WORKLOAD_REPLAY package. The use of the DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT() function also requires a license for Oracle Diagnostics Pack.
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.
Virtual assembly provisioning. For example, if there is an assembly topology of three VMs (two WebLogic Server-managed servers and one database), you will need both packs to cover the respective tiers.
On the Multitenant container database's home page, from the Oracle Database menu, select Provisioning, then Provision Pluggable Database. Next, from the PDB Operations section, select Create New Pluggable Databases. Click Launch, and from Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone.
If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using Oracle Data Masking and Subsetting Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle Database. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database.
The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database when set to TRUE. When set to TRUE, the database reports schema changes in real time into the database alert log under the message group schema_ddl. The default setting is FALSE.
From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
dd2b598166