本文不做翻译,原文转载
来源于:
Differences Between Enterprise, Standard and Standard One Editions on Oracle 11.2 (文档 ID 1084132.1)
适用于:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Mar-2015***
细节:
Feature/Option
SE1
SE
EE
Notes
High Availability
Oracle Fail Safe
Y
Y
Y
Windows only
Oracle RAC One Node
N
N
Y
Extra cost option
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
ALTERTABLE...MOVEONLINEoperations
Online table redefinition
N
N
Y
Using theDBMS_REDEFINITIONpackage
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
Requires Active Data Guard option
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
Oracle Total Recall
N
N
Y
Extra cost 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
Database Smart Flash Cache
N
N
Y
Solaris and Oracle Enterprise Linux only
Support for Oracle Exadata Storage Server Software
N
N
Y
Security
Advanced Security Option
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
Secure External Password Store
N
N
Y
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
Oracle Real Application Testing
N
N
Y
Extra cost option
Database Resource Manager
N
N
Y
Instance Caging
N
N
Y
SQL Plan Management
N
N
Y
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 Data Profiling and Quality
N
N
Y
Extra cost option
Oracle Data Watch and Repair Connector
N
N
Y
Extra cost option
Oracle Advanced Compression
N
N
Y
Extra cost option
Basic 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
In-memory Parallel Execution
N
N
Y
Parallel Statement Queuing
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
Messaging Gateway
N
N
Y
Networking
Oracle Connection Manager
N
N
Y
Available via a custom install of the Oracle Database client, usually installed on a separate machine
Infiniband Support
N
N
Y
Content Management
Oracle Spatial
N
N
Y
Extra cost option
Semantic Technologies (RDF/OWL)
N
N
Y
Requires Oracle Spatial and the Oracle Partitioning option