Oracle Enterprise Edition
features that are not available in Standard Edition
This
matrix shows Enterprise Edition features that are not available in Standard
Edition. This includes features for 10g, 11g and 12c.
|
11g
new feature not in SE
|
||||
|
12c new feature not in SE
|
||||
|
Consolidation
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Multitenant
|
N
|
|||
|
Storage snapshot optimization
|
N
|
|||
|
High Availability
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Application Continuity
|
N
|
|||
|
RAC One Node
|
N
|
|||
|
Data Guard - redo apply (physical standby)
|
N
|
N
|
N
|
|
|
Data Guard - SQL apply (logical standby)
|
N
|
N
|
N
|
|
|
Data Guard - Snapshot Standby
|
|
N
|
N
|
|
|
Active Data Guard
|
|
N
|
N
|
|
|
Data guard network compression
|
|
N
|
|
|
|
Rolling Upgrades
|
N
|
N
|
N
|
|
|
Rolling upgrades - using active data guard
|
|
|
N
|
|
|
Fast start selectable recovery time
|
N
|
|
|
|
|
Fast start fault recovery
|
|
N
|
N
|
|
|
Online index rebuild
|
|
N
|
N
|
|
|
IOT reorganization
|
|
N
|
N
|
|
|
Duplexed backup sets
|
|
|
N
|
|
|
Block change tracking for fast incremental
backup
|
|
|
N
|
|
|
Unused block compression in backups
|
|
|
N
|
|
|
Block level media recovery
|
|
|
N
|
|
|
Lost write protection
|
|
|
N
|
|
|
Automatic block repair
|
|
|
N
|
|
|
dbms_redefinition
|
N
|
N
|
|
|
|
Flashback table
|
N
|
N
|
N
|
|
|
Flashback Database
|
N
|
N
|
N
|
|
|
Flashback transaction
|
|
N
|
N
|
|
|
Optimization for Flashback Data Archive
|
|
|
N
|
|
|
Flashback transaction query
|
N
|
N
|
N
|
|
|
Flashback Data Archive (total recall)
|
|
N
|
|
|
|
Online datafile move
|
|
|
N
|
|
|
Transaction guard
|
|
|
N
|
|
|
Cross platform backup and recovery
|
|
|
N
|
|
|
Global Data Services
|
|
|
N
|
|
|
Block-level Media Recovery
|
N
|
N
|
N
|
|
|
Unused block compression in backups
|
|
N
|
N
|
|
|
Parallel backup & recovery
|
N
|
N
|
N
|
|
|
Fast RMAN Compression (ZLIB)
|
|
N
|
N
|
|
|
Point-in-time tablespace recovery
|
N
|
N
|
N
|
|
|
Trial recovery
|
N
|
N
|
N
|
|
|
Recovering tables from RMAN backups
|
|
|
N
|
|
|
Scalability
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Real Application Clusters (RAC)
|
Y
|
Y
|
Y
|
|
|
Quality of service management
|
|
|
N
|
|
|
Support for Exadata storage server
|
|
N
|
N
|
|
|
In memory database cache
|
|
N
|
|
|
|
Concurrent execution of UNION branches
|
|
|
N
|
|
|
In memory column store
|
|
|
N
|
|
|
Fault tolerant in memory column store
|
|
|
N
|
|
|
In memory aggregation
|
|
|
N
|
|
|
Attribute clustering
|
|
|
N
|
|
|
Zone maps
|
|
|
N
|
|
|
Adaptive execution plans
|
|
|
N
|
|
|
Security
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Advanced Security option
|
N
|
N
|
N
|
|
|
Database vault
|
|
|
N
|
|
|
Oracle Label Security
|
N
|
N
|
N
|
|
|
Enterprise security
|
|
|
N
|
|
|
Data Masking Pack
|
|
N
|
|
|
|
Virtual Private Database
|
N
|
N
|
N
|
|
|
Fine Grained Auditing
|
N
|
N
|
N
|
|
|
Privilege analysis
|
|
|
N
|
|
|
Real Application Security
|
|
|
N
|
|
|
Redaction
|
|
|
N
|
|
|
Transparent sensitive data protection
|
|
|
N
|
|
|
Secure Application Role
|
|
N
|
|
|
|
Performance
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
PL/SQL function result cache
|
|
N
|
N
|
|
|
Times Ten application-tier database cache
|
|
|
N
|
|
|
Database smart flash cache
|
|
|
N
|
|
|
Client-side query cache
|
|
N
|
N
|
|
|
Query result cache
|
|
|
N
|
|
|
Manageability
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Change Management Pack
|
N
|
N
|
|
|
|
Configuration Management Pack
|
N
|
N
|
|
|
|
Cloud management pack
|
|
|
N
|
|
|
Data Masking Pack and sub-setting
|
|
|
N
|
|
|
Lifecycle management pack
|
|
|
N
|
|
|
Diagnostic Pack
|
N
|
N
|
N
|
|
|
Tuning Pack
|
N
|
N
|
N
|
|
|
Provisioning and Patch automation pack
|
|
N
|
|
|
|
Duplexed backup sets
|
N
|
N
|
|
|
|
Database Resource Manager
|
N
|
N
|
N
|
|
|
Instance caging
|
|
|
N
|
|
|
SQL Plan management
|
|
N
|
N
|
|
|
Rapid Home provisioning
|
|
|
N
|
|
|
VLDB, Data Warehousing,
BI
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Partitioning option
|
N
|
N
|
N
|
|
|
OLAP option
|
N
|
N
|
N
|
|
|
Advanced analytics
|
|
N
|
N
|
|
|
Advanced compression
|
|
|
N
|
|
|
Advanced index compression
|
|
|
N
|
|
|
Prefix compression (key compression)
|
|
|
N
|
|
|
Hybrid columnar compression
|
|
|
N
|
|
|
Exadata flash cache compression
|
|
|
N
|
|
|
Heat maps
|
|
|
N
|
|
|
automatic data optimization
|
|
|
N
|
|
|
basic table compression
|
|
|
N
|
|
|
Deferred segment creation
|
|
|
N
|
|
|
Direct Load data compression
|
|
N
|
|
|
|
OLTP compression
|
|
N
|
|
|
|
Data Mining Option
|
N
|
|
|
|
|
Data Compression
|
N
|
|
|
|
|
Bitmap index & bitmap join index
|
N
|
N
|
N
|
|
|
Parallel query/ DML
|
N
|
N
|
N
|
|
|
Parallel CBO statistics gathering
|
N
|
N
|
N
|
|
|
Parallel index builds/scans
|
N
|
N
|
N
|
|
|
Parallel data pump export/import
|
N
|
N
|
N
|
|
|
In-memory parallel execution
|
|
|
N
|
|
|
Parallel statement queueing
|
|
|
N
|
|
|
Parallel capture and apply via Xstream
|
|
|
N
|
|
|
Data Pump Compression
|
|
N
|
|
|
|
Export transportable tablespaces
|
|
N
|
|
|
|
Transportable tablespaces
|
N
|
|
N
|
|
|
Materialized views - query rewrite
|
N
|
N
|
N
|
|
|
Asynchronous Data Change Capture
|
N
|
N
|
|
|
|
Query rewrite cache
|
|
N
|
|
|
|
Integration
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Oracle Streams
|
N
|
Y
|
Y
|
|
|
Messaging gateway
|
N
|
N
|
N
|
|
|
Sharded queues
|
|
|
N
|
|
|
Advanced Replication
|
N
|
N
|
N
|
|
|
Distributed queries
|
N
|
Y
|
|
|
|
Networking
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Connection Manager (CMAN)
|
N
|
N
|
N
|
|
|
infiniband Support
|
N
|
N
|
N
|
|
|
Spatial and Graph Data
|
SE 10g
|
SE 11g
|
SE 12c
|
|
|
Oracle Spatial
|
N
|
N
|
N
|
|
|
Semantic Technologies (RDF/OWL)
|
|
N
|
N
|
|
|
Network Compression
|
|
|
N
|
|
|
Network encryption (SSL/TLS)
|
|
|
N
|
|
|
Parallel spatial index builds
|
|
|
N
|
|
|
Multimaster replication of SDO_GEOMETRY
objects
|
|
|
N
|
|
|
Partitioned spatial indexes
|
|
|
N
|
I hope you all have
enjoyed reading this article. Comments are welcome....
No comments:
Post a Comment