标准版不允许并行、分区、闪回、各种缓存等大数据量必须特性,如此限制,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