Oracle 19c Enterprise Edition - Options, Features and Management Packs

Oracle provides database software and programs in several offerings with different functionality and features, and with additional options together with different management packs. The following compilation shows which Oracle offerings, options and management packs that can be used together with IFS Cloud.

Oracle Database Offerings

Oracle Database Offering	Support for IFS Cloud	Comments
Oracle Database Standard Edition 2	Y	Limited to 1 CDB & 3 PDB and 16 threads.
Oracle Database Enterprise Edition	Y	Oracle DB ASFU license for IFS Cloud.
Oracle Database Express Edition	Y	Only for development usage.
Oracle Database Enterprise Edition on Oracle Exadata Database Machine	Y	Verified for IFS Applications 9 and Oracle 12.2.0.1
Oracle Database Cloud Service Standard Edition	N	Only available in Oracle Cloud - OCI.
Oracle Database Cloud Service Enterprise Edition	N	Only available in Oracle Cloud - OCI.
Oracle Database Cloud Service Enterprise Edition - High Performance	N	Only available in Oracle Cloud - OCI.
Oracle Database Cloud Service Enterprise Edition - Extreme Performance	N	Only available in Oracle Cloud - OCI.
Oracle Database Exadata Cloud Service	N	Only available in Oracle Cloud - OCI.

Oracle Database Options

Oracle Database Options come with addition cost.

Oracle Database Option	Can be used with IFS Cloud	Comments
Oracle Active Data Guard	Y	Verified on IFS Applications 10.
Oracle Advanced Analytics	N	Not tested/verified for IFS Cloud.
Oracle Advanced Compression	Y	Verified on IFS Applications 9 and 10. Advanced Row Compression, Advanced Index Compression, Advanced LOB compression and Hybrid Columnar Compression have been tested/verified.
Oracle Advanced Security	Y	Verified on IFS Applications 10. Transparent Data Encryption (TDE) and Data Pump Encryption have been tested/verified.
Oracle Database In-Memory	Y	Verified on IFS Applications 10. In-Memory functionality in IFS Applications 10 requires this option.
Oracle Database Vault	N	Not tested/verified for IFS Cloud.
Oracle Label Security	N	Not tested/verified for IFS Cloud.
Oracle Multitenant	Y	Verified on IFS Applications 10. Only one pluggable database per container is supported for IFS Applications 10.
Oracle On-Line Analytical Processing (OLAP)	N	Not tested/verified for IFS Cloud.
Oracle Partitioning	Y	Verified on IFS Applications 9 & 10. Table partitioning, global and local index partitions have been tested/verified.
Oracle RAC One Node	Y	Included in SE2, extra cost in EE. Database cold failover to another node in the cluster have not been tested, but should work since RAC One Node use the same framework as Oracle RAC does.
Oracle Real Application Clusters (Oracle RAC)	Y	Verified on both IFS Applications 9 & 10. Up to 4 RAC nodes are supported (with acceptable performance) for IFS Cloud.
Oracle Real Application Testing	N	Not tested/verified for IFS Cloud.
Oracle Spatial and Graph	N	Not tested/verified for IFS Cloud.
Oracle TimesTen Application-Tier Database Cache	N	Not tested/verified for IFS Cloud.

Oracle Management Packs

Oracle Management Packs come with additional cost.

Oracle Management Pack	Can be used with IFS Cloud	Comments
Oracle Cloud Management Pack for Oracle Database	N	Not tested/verified for IFS Cloud.
Oracle Data Masking and Subsetting Pack	Y	Verified on IFS Applications 10.
Oracle Database Lifecycle Management Pack for Oracle Database	N	Not tested/verified for IFS Cloud.
Oracle Diagnostics Pack	Y	Verified on IFS Applications 9 & 10. Oracle Diagnostics Pack is required for AWR and ADDM.
Oracle Tuning Pack	Y	Verified on IFS Applications 9 & 10. Oracle Tuning Pack is required for SQL Access Advisor, SQLTuning Advisor, In-Memory Advisor, Real-time SQL and PL/SQL Monitoring, Real-time Database Operations Monitoring and reorganize objects.