Oracle Database Feature Availability
The table below lists features availability for Oracle Database Standard Edition One (SE1), Standard Edition (SE), Standard Edition 2 (SE2), and Enterprise Edition (EE).
Note that Oracle Database XE is separate from the rest of the Oracle Database product family. The features available with Oracle Database XE are documented in Oracle Database Express Edition Licensing Information, which is installed along with the product. The current version of Oracle Database XE is Oracle Database 11g Release 2.
Note:
Oracle Database Standard Edition 2 (SE2) is available starting with Oracle Database 12c Release 1 (12.1.0.2). For 12.1.0.1, Oracle Database Standard Edition One (SE1) and Oracle Database Standard Edition (SE) are available.
Feature/Option | SE1 | SE/SE2 | EE |
Consolidation | |||
Multitenant | N | N | Y |
Snapshots and Cloning | |||
Storage Snapshot Optimization | N | N | Y |
High Availability | |||
Application Continuity | N | N | Y |
Oracle Fail Safe | Y | Y | Y |
Oracle RAC One Node | N | N | Y |
Oracle Data Guard—Redo Apply | N | N | Y |
Oracle Data Guard—Far Sync Standby | N | N | Y |
Oracle Data Guard—SQL Apply | N | N | Y |
Oracle Data Guard—Snapshot Standby | N | N | Y |
Oracle Data Guard—Real-Time Cascading Standbys | N | N | Y |
Oracle Active Data Guard | N | N | Y |
Rolling Upgrades—Patch Set, Database, and Operating System | N | N | Y |
Rolling Upgrade Using Active Data Guard | N | N | Y |
Online index rebuild | N | N | Y |
Online index-organized table organization | N | N | Y |
Online table redefinition | N | N | Y |
Duplexed backup sets | N | N | Y |
Block change tracking for fast incremental backup | N | N | Y |
Unused block compression in backups | N | N | Y |
Block-level media recovery | N | N | Y |
Lost Write Protection | N | N | Y |
Automatic Block Repair | N | N | Y |
Parallel backup and recovery | N | N | Y |
Tablespace point-in-time recovery | N | N | Y |
Trial recovery | N | N | Y |
Fast-start fault recovery | N | N | Y |
Flashback Table | N | N | Y |
Flashback Database | N | N | Y |
Flashback Transaction | N | N | Y |
Flashback Transaction Query | N | N | Y |
Optimization for Flashback Data Archive | N | N | Y |
Online Datafile Move | N | N | Y |
Transaction Guard | N | N | Y |
Cross-platform Backup and Recovery | N | N | Y |
Global Data Services | N | N | Y |
Recovering tables and table partitions from RMAN backups | N | N | Y |
Scalability | |||
Oracle Real Application Clusters | N | Y | Y |
Automatic Workload Management | N | Y | Y |
Quality of Service Management | N | N | Y |
Oracle NoSQL Database Basic Edition | N | N | Y |
Performance | |||
Client Side Query Cache | N | N | Y |
Query Results Cache | N | N | Y |
PL/SQL Function Result Cache | N | N | Y |
TimesTen Application-Tier Database Cache | N | N | Y |
Database Smart Flash Cache | N | N | Y |
Support for Oracle Exadata Storage Server Software | N | N | Y |
Adaptive Execution Plans | N | N | Y |
Concurrent Execution of UNION and UNION ALL Branches | N | N | Y |
In-Memory Column Store | N | N | Y |
Fault Tolerant In-Memory Column Store | N | N | Y |
In-Memory Aggregation | N | N | Y |
Attribute Clustering | N | N | Y |
Zone Maps | N | N | Y |
Security | |||
Oracle Advanced Security | N | N | Y |
Oracle Database Vault | N | N | Y |
Oracle Label Security | N | N | Y |
Enterprise User Security | N | N | Y |
Fine-grained Auditing | N | N | Y |
Privilege Analysis | N | N | Y |
Real Application Security | N | N | Y |
Redaction | N | N | Y |
Transparent Sensitive Data Protection | N | N | Y |
Virtual Private Database | N | N | Y |
Development Platform | |||
SQLJ | Y | Y | Y |
Oracle Developer Tools for Visual Studio .NET | Y | Y | Y |
Microsoft Distributed Transaction Coordinator support | Y | Y | Y |
Active Directory integration | Y | Y | Y |
Native .NET Data Provider—ODP.NET | Y | Y | Y |
.NET Stored Procedures | Y | Y | Y |
Manageability | |||
Oracle Cloud Management Pack for Oracle Database | N | N | Y |
Oracle Data Masking and Subsetting Pack | N | N | Y |
Oracle Database Lifecycle Management Pack for Oracle Database | N | N | Y |
Oracle Diagnostics Pack | N | N | Y |
Oracle Tuning Pack | N | N | Y |
Oracle Real Application Testing | N | N | Y |
Database Resource Manager | N | N | Y |
Instance Caging | N | Included with SE2 and EE | Y |
SQL Plan Management | N | N | Y |
SQL Tuning Sets | N | N | Y |
Rapid Home Provisioning | N | N | Y |
VLDB, Data Warehousing, Business Intelligence | |||
Oracle Partitioning | N | N | Y |
Oracle OLAP | N | N | Y |
Oracle Advanced Analytics | N | N | Y |
Oracle Advanced Compression | N | N | Y |
Advanced Index Compression | N | N | Y |
Prefix Compression (also called Key Compression) | N | N | Y |
Hybrid Columnar Compression | N | N | Y |
Hybrid Columnar Compression Row-Level Locking | N | N | Y |
Exadata Flash Cache Compression | N | N | Y |
Heat Map | N | N | Y |
Automatic Data Optimization | N | N | Y |
Basic Table Compression | N | N | Y |
Deferred Segment Creation | N | N | Y |
Bitmapped index, bitmapped join index, and bitmap plan conversions | N | N | Y |
Parallel query/DML | N | N | Y |
Parallel statistics gathering | N | N | Y |
Parallel index build/scans | N | N | Y |
Parallel Data Pump Export/Import | N | N | Y |
In-memory Parallel Execution | N | N | Y |
Parallel Statement Queuing | N | N | Y |
Parallel capture and apply via XStream | N | N | Y |
Transportable tablespaces, including cross-platform and full transportable export and import | N | N | Y |
Summary management—Materialized View Query Rewrite | N | N | Y |
Integration | |||
Basic Replication | Y | Y | Y |
Advanced Replication | N | N | Y |
Oracle Streams | Y | Y | Y |
Database Gateways | Y | Y | Y |
Messaging Gateway | N | N | Y |
Sharded Queues | N | N | Y |
Networking | |||
Oracle Connection Manager | N | N | Y |
Infiniband Support | N | N | Y |
Network Compression | N | N | Y |
Network Encryption (SSL/TLS) | Y | Y | Y |
Spatial and Graph Data | |||
Oracle Spatial and Graph | N | N | Y |
Graph and Semantic Technologies (RDF/OWL) | N | N | Y |
Parallel spatial index builds | N | N | Y |
Multimaster replication of SDO_GEOMETRY objects | N | N | Y |
Partitioned spatial indexes | N | N | Y |
Note:
- Oracle Database XE is separate from the rest of the Oracle Database product family. The features available with Oracle Database XE are documented in Oracle Database Express Edition Licensing Information, which is installed along with the product. The current version of Oracle Database XE is Oracle Database 11g Release 2.
- Oracle Database Standard Edition 2 (SE2) is available starting with Oracle Database 12c Release 1 (12.1.0.2). For 12.1.0.1, Oracle Database Standard Edition One (SE1) and Oracle Database Standard Edition (SE) are available.
Data provided here is based on information listed on Oracle Cooptation documentation.