|
Oracle Database Express Edition
|
Oracle Database Standard Edition One
|
Oracle Database Standard Edition
|
Oracle Database Enterprise Edition
|
| Maximum |
1 CPU |
2 Sockets |
4 Sockets |
No Limit |
| RAM |
1GB |
OS Max |
OS Max |
OS Max |
| Database Size |
11GB |
No Limit |
No Limit |
No Limit |
| Oracle Multitenant |
|
|
|
Option |
Big Data and Data Warehousing
|
| Oracle Advanced Compression |
|
|
|
Option |
| Oracle OLAP |
|
|
|
Option |
| Oracle Partitioning |
|
|
|
Option |
| Oracle Advanced Analytics |
|
|
|
Option |
| Transportable Tablespaces, Including Cross-Platform |
|
|
|
 |
| Star Query Optimization |
PL/SQL only |
|
|
|
| Summary Management – Materialized View Query Rewrite |
|
|
|
|
| Information Lifecycle Management |
|
|
|
|
High Availability
|
| Oracle Active Data Guard |
|
|
|
Option |
| Data Guard |
|
|
|
|
| Transaction Guard |
|
|
|
|
| Cross-Platform Recovery |
|
|
|
|
| Cross-Platform Backup |
|
|
|
|
| Fail Safe |
|
|
|
|
| Flashback Query |
|
|
|
|
| Flashback Table, Database and Transaction Query |
|
|
|
|
| Oracle Secure Backup |
Oracle Secure Backup is its own product that works with each Oracle Database edition. |
| Server Managed Backup and Recovery |
|
|
|
|
Performance and Scalability
|
| Oracle Real Application Clusters |
|
|
|
Option |
| Oracle Real Application Clusters One Node |
|
|
|
Option |
| Adaptive Execution Plans |
|
|
|
|
| Integrated Clusterware |
|
|
|
|
| Automatic Workload Management |
|
|
|
|
| Java, PL/SQL Native Compilation |
PL/SQL only |
|
|
|
| Oracle In-Memory Database Cache |
|
|
|
Option |
Security Defense in Depth
|
| Data Masking |
|
|
|
Requires Oracle Data Masking Pack |
| Real Application Security |
|
|
|
|
| Oracle Database Vault |
|
|
|
Option |
| Oracle Audit Vault and Database Firewall |
Oracle Audit Vault is its own product that works with each Oracle Database edition. |
| Oracle Advanced Security |
|
|
|
Option |
| Oracle Label Security |
|
|
|
Option |
| Secure Application Roles |
|
|
|
|
| Oracle Virtual Private Database |
|
|
|
|
| Fine-Grained Auditing |
|
|
|
|
| Proxy Authentication |
|
|
|
|
| Data Encryption Toolkit |
|
|
|
|
Application Development
|
| Oracle Flashback Data Archive |
|
|
|
|
| SQL Pattern Matching |
|
|
|
|
| Temporal Database |
|
|
|
|
| Oracle SQL Developer |
|
|
|
|
| Oracle Application Express |
|
|
|
|
| Java Support |
|
|
|
|
| Comprehensive XML Support |
|
|
|
|
| PL/SQL |
PL/SQL only |
|
|
|
| Comprehensive Microsoft .Net Support, OLE DB, ODBC |
|
|
|
|
Manageability
|
| Oracle Real Application Testing |
|
|
|
Option |
| Oracle Enterprise Manager |
|
|
|
|
| Automatic Memory Management |
|
|
|
|
| Oracle Automatic Storage Management |
|
|
|
|
| Automatic Undo Management |
|
|
|
|
Integration
|
| Basic Replication |
|
|
|
|
| Distributed Queries/Transactions |
|
|
|
|
Unstructured Data Management
|
| Oracle Spatial and Graph |
|
|
|
Option |
| XML DB |
|
|
|
|
| Multimedia |
|
|
|
|
| Text |
|
|
|
|
| Locator |
|
|
|
|
| Oracle Secure Enterprise Search |
Oracle Secure Enterprise Search is its own product that works with each Oracle Database edition. |
