Differences Between Enterprise, Standard and Standard One Editions on Oracle 11.2 (Doc ID 1084132.1)

标准版不允许并行、分区、闪回、各种缓存等大数据量必须特性，如此限制，oracle摆明了只卖企业版，买标准版不如mysql（如果不熟悉postgresql的话）。

Oracle企业版1 CPU 20w起，理论上最多打7折，官方75折起步，买了oracle还指望不用oracle各种特性、所谓平台无关的，真是钱烧的慌。报价各总结参考http://www.askmaclean.com/archives/oracle-ee.html，https://www.cnblogs.com/yingsong/p/4437704.html。

详细可参考官方文档https://docs.oracle.com/cd/E11882_01/license.112/e47877.pdf。

Differences Between Enterprise, Standard and Standard One Editions on Oracle 11.2 (Doc ID 1084132.1)

Applies to:

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 19-Jun-2012***

Purpose

To show the option differences between the different editions of Oracle 11.2 server

SOURCE:

Oracle? Database Licensing Information 11g Release 2 (11.2) Part Number E10594-04

      Chapter 1 Oracle Database Editions

Details

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 See "Oracle Connection Manager" for more information
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

References

NOTE:465465.1 - Differences Between Enterprise, Standard and Personal Editions on Oracle 10.2
NOTE:269040.1 - Differences Between Enterprise, Standard and Personal Editions on Oracle 9.2
NOTE:465460.1 - Differences Between Enterprise, Standard and Personal Editions on Oracle 11.1