Consolidation

Multitenant

Snapshots and Cloning

Storage Snapshot Optimization

High Availability

Application Continuity

N

Y

Requires the Active Data Guard option or the Real Application Clusters option

Oracle Sharding

N

Y

No limit on the number of either Primary shards or Standby shards if every shard has an ADG, GG or RAC license. Without those license use is limited to 3 primary shards with basic DG standbys

Oracle Fail Safe

Y

Y

Windows only

Oracle RAC One Node

N

Y

Extra cost option

Oracle Data Guard—Redo Apply

N

Y

Oracle Data Guard— Far Sync Standby

N

Y

Oracle Data Guard—SQL Apply

N

Y

Oracle Data Guard—Snapshot Standby

N

Y

Oracle Data Guard—Real-Time Cascading Standby

N

Y

Requires the Active Data Guard option

Oracle Active Data Guard

N

Y

Extra cost option

Rolling Upgrades—Patch Set, Database, and Operating System

N

Y

Rolling Upgrade using Active Data Guard

N

Y

Online index rebuild

N

Y

Online index-organized table organization

N

Y

ALTERTABLE...MOVEONLINEoperations

Online table redefinition

N

Y

Using theDBMS_REDEFINITIONpackagehttp://www.cndba.cn/dave/article/2980

Duplexed backup sets

N

Y

Block change tracking for fast incremental backup

N

Yhttp://www.cndba.cn/dave/article/2980

Unused block compression in backups

N

Y

Block-level media recovery

N

Y

Lost Write Protection

N

Y

Automatic Block Repair

N

Y

Requires Active Data Guard option

Parallel backup and recovery

N

Y

Tablespace point-in-time recovery

N

Y

Trial recovery

N

Yhttp://www.cndba.cn/dave/article/2980

Fast-start fault recovery

N

Y

Flashback Table

N

Y

Flashback Database

N

Y

Flashback Transaction

N

Y

Flashback Transaction Query

N

Y

Optimization for Flashback Data Archive

N

Y

Basic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option.

Online Datafile Move

N

Y

Transaction Guard

N

Y

Cross-platform Backup and Recovery

N

Y

Global Data Services

N

Y

Recovering tables and table partitions from RMAN backups

N

Y

Scalability

Oracle Real Application Clusters

Y

Y

Extra cost with EE, included with SE

Automatic Workload Management

Y

Y

Requires Oracle Real Application Clusters

Quality of Service Management

Y

Y

Requires Oracle Real Application Clusters

Oracle NoSQL Database Basic edition

N

Y

Performance

Client Side Query Cache

N

Y

Query Results Cache

N

Y

PL/SQL Function Result Cache

N

Y

In-Memory Database Cache

N

Y

Extra cost option

Database Smart Flash Cache

N

Y

Solaris and Oracle Enterprise Linux only

Support for Oracle Exadata Storage Server Software

N

Y

Adaptive Execution Plans

N

Y

Concurrent Execution of UNION and UNION ALL Branches

N

Y

In-Memory Column Store

N

Y

Attribute Clustering

N

Y

Zone Maps

N

N

Security

Tablespace Encryption

N

Y

Requires the Advanced Security option

Advanced Security Option

N

Y

Extra cost option

Oracle Label Security

N

Y

Extra cost option

Oracle Database Vault

Nhttp://www.cndba.cn/dave/article/2980

Y

Extra cost option

Virtual Private Database

N

Y

Fine-grained auditing

N

Y

Enterprise User Security

Real Application Security

N

Y

Redaction

N

Y

Privilege Analysis

N

Y

Transparent Sensitive Data Protection

N

Y

Virtual Private Database

N

Y

Development Platform

SQLJ

Y

Y

Requires Oracle Programmer

Oracle Developer Tools for Visual Studio .NET

Y

Y

Windows only

Microsoft Distributed Transaction Coordinator support

Y

Y

Windows only

Active Directory integration

Y

Y

Windows only

Native .NET Data Provider—ODP.NET

Y

Y

Windows only

.NET Stored Procedures

Y

Y

Windows only

Manageability

Oracle Cloud Management Pack for Oracle Database

N

Y

Extra cost option

Oracle Data Masking Pack 

N

Y

Extra cost option

Oracle Database Lifecycle Management Pack for Oracle database

N

Y

Extra cost option

Oracle Diagnostic Pack

N

Y

Extra cost option

Oracle Tuning Pack

N

Y

Extra cost option, also requires the Diagnostic Pack

Oracle Real Application Testing

N

Y

Extra cost option

Database Resource Manager

N

Y

I/O Resource Management

N

N

Instance Caging

Y

Y

SQL Plan Management

N

Y

SQL Tuning sets

N

Y

VLDB, Data Warehousing, Business Intelligence

Oracle Partitioning

N

Y

Extra cost option

Oracle OLAP

N

Y

Extra cost option

Oracle Advanced Analytics

N

Y

Extra cost option

Oracle Advanced Compression

N

Y

Extra cost option

Advanced Index Compression

N

Y

Requires the Advanced Compression option

Prefix Compression ( Key Compression)

N

Y

Hybrid Columnar Compression

N

Y

Requires  ZFS, Axiom or FS1 storage

Hybrid Columnar Compression Row-Level Locking

N

Y

Requires ZFS or FS1 storage, and the Advanced Compression option

Heat Map

N

Y

Requires the Advanced Compression option

Deferred Segment Creation

N

Y

Bitmapped index, bitmapped join index, and bitmap plan conversions

N

Y

Parallel query/DML

N

Y

Parallel statistics gathering

N

Y

Parallel index build/scans

Nhttp://www.cndba.cn/dave/article/2980

Y

Parallel Data Pump Export/Import

N

Y

In-memory Parallel Execution

N

Y

Parallel Statement Queuing

N

Y

Parallel capture and apply via XStream

N

Y

Transportable tablespaces, including cross-platform and Full Transportable export and import

N

Y

Import of transportable tablespaces supported into SE, SE1, and EE

Summary management—Materialized View Query Rewrite

N

Y

Integration

Basic Replication

Y

Y

SE2 read-only, updateable materialized view

Oracle Streams

Y

Y

SE2: no capture from redo

Database Gateways

Y

Y

Separate product license

Messaging Gateway

N

Y

Sharded Queues

N

Y

Networking

Oracle Connection Manager

N

Y

Available via a custom install of the Oracle Database client, usually installed on a separate machine

Infiniband Support

N

Y

Network Compression

N

Y

Network Encryption (SSL/TLS)

Y

Y

Spatial and Graph Data

Oracle Spatial and Graph

N

Y

Extra cost option

Graph and Semantic Technologies (RDF/OWL)

N

Y

Requires the Oracle Spatial and Graph option and the Oracle Partitioning option

Parallel spatial indexes

N

Y

Requires Oracle Partitioning option