Oracle 11gR2版本區別明細

eric_zhyd發表於2013-12-05
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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12974804/viewspace-1062307/,如需轉載,請註明出處,否則將追究法律責任。

相關文章