Wednesday, April 17, 2013

Feature Availability by Oracle Database Edition

 Feature Availability for Oracle Database Editions
Feature/Option SE1 SE EE Notes
High Availability
       
Oracle Fail Safe
Y
Y
Y
Windows only
Oracle Data Guard—Redo Apply
N
N
Y
 
Oracle Data Guard—SQL Apply
N
N
Y
 
Oracle Data Guard—Snapshot Standby
N
N
Y
 
Oracle Active Data Guard
N
N
Y
Extra cost option
Rolling Upgrades—Patch Set, Database, and Operating System
N
N
Y
 
Online index rebuild
N
N
Y
 
Online index-organized table organization
N
N
Y
ALTER TABLE ... MOVE ONLINE operations
Online table redefinition
N
N
Y
Using the DBMS_REDEFINITION package
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
 
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
 
Flashback Data Archive (Total Recall)
N
N
Y
Requires Oracle Advanced Compression option
Scalability
       
Oracle Real Application Clusters
N
Y
Y
Extra cost with EE, included with SE
Automatic Workload Management
N
Y
Y
Requires Oracle Real Application Clusters
Performance
       
Client Side Query Cache
N
N
Y
 
Query Results Cache
N
N
Y
 
PL/SQL Function Result Cache
N
N
Y
 
In-Memory Database Cache
N
N
Y
Extra cost option
SQL Plan Management
N
N
Y
 
Support for Oracle Exadata Storage Server
N
N
Y
 
Support for Oracle Exadata Storage Server Software
N
N
Y
 
Security
       
Oracle Advanced Security
N
N
Y
Extra cost option
Oracle Label Security
N
N
Y
Extra cost option
Virtual Private Database
N
N
Y
 
Fine-grained auditing
N
N
Y
 
Oracle Database Vault
N
N
Y
Extra cost option
Development Platform
       
SQLJ
Y
Y
Y
Requires Oracle Programmer
Oracle Developer Tools for Visual Studio .NET
Y
Y
Y
Windows only
Microsoft Distributed Transaction Coordinator support
Y
Y
Y
Windows only
Active Directory integration
Y
Y
Y
Windows only
Native .NET Data Provider—ODP.NET
Y
Y
Y
Windows only
.NET Stored Procedures
Y
Y
Y
Windows only
Manageability
       
Oracle Change Management Pack
N
N
Y
Extra cost option
Oracle Configuration Management Pack
N
N
Y
Extra cost option
Oracle Diagnostic Pack
N
N
Y
Extra cost option
Oracle Tuning Pack
N
N
Y
Extra cost option, also requires the Diagnostic Pack
Oracle Provisioning and Patch Automation Pack
N
N
Y
Extra cost option
Database Resource Manager
N
N
Y
 
Oracle Real Application Testing
N
N
Y
Extra cost option
VLDB, Data Warehousing, Business Intelligence
       
Oracle Partitioning
N
N
Y
Extra cost option
Oracle OLAP
N
N
Y
Extra cost option
Oracle Data Mining
N
N
Y
Extra cost option
Oracle Advanced Compression
N
N
Y
Extra cost option
Direct-Load Table Compression
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
 
Transportable tablespaces, including cross-platform
N
N
Y
Import of transportable tablespaces supported into SE, SE1, and EE
Summary management—Materialized View Query Rewrite
N
N
Y
 
Asynchronous Change Data Capture
N
N
Y
 
Integration
       
Basic Replication
Y
Y
Y
SE1/SE: read-only, updateable materialized view
Advanced Replication
N
N
Y
Multi-master replication
Oracle Streams
Y
Y
Y
SE1/SE: no capture from redo
Database Gateways
Y
Y
Y
Separate product license
Networking
       
Oracle Connection Manager
N
N
Y
 
Infiniband Support
N
N
Y
 
Content Management
       
Oracle Spatial and Graph
N
N
Y
Extra cost option
Semantic Technologies (RDF/OWL)
N
N
Y
Requires the Oracle Spatial and Graph option and the Oracle Partitioning option

No comments:

Post a Comment