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 Applications 10
| Oracle Database Offering |
Support for IFS Applications 10 |
Comments |
|---|---|---|
| Oracle Database Standard Edition 2 | Y | Limited to 1 CDB & 1 PDB and 16 threads. |
| Oracle Database Enterprise Edition | Y | Oracle DB ASFU license for IFS Applications 10. |
| 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 come with addition cost.
| Oracle Database Option |
Can be used with IFS Applications 10 |
Comments |
|---|---|---|
| Oracle Active Data Guard | Y | Verified on IFS Applications 10. |
| Oracle Advanced Analytics | N | Not tested/verified for IFS Applications. |
| 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 Applications. |
| Oracle Label Security | N | Not tested/verified for IFS Applications. |
| 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 Applications. |
| 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 Applications. |
| Oracle Real Application Testing | N | Not tested/verified for IFS Applications. |
| Oracle Spatial and Graph | N | Not tested/verified for IFS Applications. |
| Oracle TimesTen Application-Tier Database Cache | N | Not tested/verified for IFS Applications. |
Oracle Management Packs come with additional cost.
| Oracle Management Pack |
Can be used with IFS Applications 10 |
Comments |
|---|---|---|
| Oracle Cloud Management Pack for Oracle Database | N | Not tested/verified for IFS Applications. |
| 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 Applications. |
| 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. |