签到成功

知道了

CNDBA社区CNDBA社区

Oracle 18c 中 SE2 和 EE 版本功能的区别

2018-08-30 19:58 3845 0 转载 Oracle 18c
作者: dave

在之前Oracle 18c 的安装博客中,我们看到在软件版本选择的时候是EE和SE2, 这个与之前稍有区别。

Oracle 18c 单实例安装手册 详细截图版

https://www.cndba.cn/dave/article/2971


正好在MOS( ID 2243031.1)上看到他们区别,转帖过来:

详细对比如下

Feature/Option SE2 EE Notes

Consolidation

     

Multitenant

1 252 Extra cost option; With Multitenant license up to 252 pluggable databases can be created. The multitenant architecture with one pluggable database (single tenant) is available in all editions

Snapshots and Cloning

     

Storage Snapshot Optimization

N Y Requires advanced compression option

High Availability

     

Application Continuity

N

Y

Requires the Active Data Guard option or the Real Application Clusters option

Oracle Sharding

N

Y

No limit on the number of either Primary shards or Standby shards if every shard has an ADG, GG or RAC license. Without those license use is limited to 3 primary shards with basic DG standbyshttps://www.cndba.cn/cndba/dave/article/2980

Oracle Fail Safe

Y

Y

Windows only

https://www.cndba.cn/cndba/dave/article/2980

Oracle RAC One Node

N

Y

Extra cost option

Oracle Data Guard—Redo Apply

N

Y

 

Oracle Data Guard— Far Sync Standby

N

Y

Requires the Active Data Guard option

Oracle Data Guard—SQL Apply

N

Y

 

Oracle Data Guard—Snapshot Standby

N

Y

 

Oracle Data Guard—Real-Time Cascading Standby

N

Y

Requires the Active Data Guard option

Oracle Active Data Guard

N

Y

Extra cost option

Rolling Upgrades—Patch Set, Database, and Operating System

N

Y

 

Rolling Upgrade using Active Data Guard

N

Y

Requires the Active Data Guard option

Online index rebuild

N

Y

 

Online index-organized table organization

N

Y

ALTERTABLE...MOVEONLINEoperations

Online table redefinition

N

Y

Using theDBMS_REDEFINITIONpackage

Duplexed backup sets

N

Y

 

Block change tracking for fast incremental backup

N

Y

 

Unused block compression in backups

N

Y

 

Block-level media recovery

N

Y

 

Lost Write Protection

N

Y

 

Automatic Block Repair

N

Y

Requires Active Data Guard option

Parallel backup and recoveryhttps://www.cndba.cn/cndba/dave/article/2980

N

Y

 

Tablespace point-in-time recovery

N

Y

 

Trial recovery

N

Y

 

Fast-start fault recovery

N

Y

 

Flashback Table

N

Y

 

Flashback Database

N

Y

 

Flashback Transaction

N

Y

 

Flashback Transaction Query

N

Y

 

Optimization for Flashback Data Archive

N

Y

Basic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option.

Online Datafile Move

N

Y

 

Transaction Guard

N

Y

 

Cross-platform Backup and Recovery

N

Y

 

Global Data Services

N

Y

Requires the Active Data Guard option

Recovering tables and table partitions from RMAN backups

N

Y

 

Scalability

     

Oracle Real Application Clusters

Y

Y

Extra cost with EE, included with SE

Automatic Workload Management

Y

Y

Requires Oracle Real Application Clusters

Quality of Service Management

Y

Y

Requires Oracle Real Application Clusters

Oracle NoSQL Database Basic edition

N

Y

 

Performance

     

Client Side Query Cache

N

Y

 

Query Results Cache

N

Y

 

PL/SQL Function Result Cache

N

Y

 

In-Memory Database Cache

N

Y

Extra cost option

Database Smart Flash Cache

N

Y

Solaris and Oracle Enterprise Linux only

Support for Oracle Exadata Storage Server Software

N

Y

 

Adaptive Execution Plans

N

Y

 

Concurrent Execution of UNION and UNION ALL Branches

N

Y

 

In-Memory Column Store

N

Y

Requires the Database In-Memory option
In-Memory column store on Active data guard standby N N  
Fault Tolerant In-Memory column store N Y Requires Database Appliance, the Database In-Memory option, RAC option
In-Memory Aggregation N Y Requires Database in-Memory option

Attribute Clustering

N

Y

 

Zone Maps

N

N

 

Security

     
Column-Level Encryption N Y Requires the Advanced Security option

Tablespace Encryption

N

Y

Requires the Advanced Security option

Advanced Security Option

N

Y

Extra cost option

Oracle Label Security

N

Y

Extra cost option

Oracle Database Vault

N

Y

Extra cost option

Virtual Private Database

N

Y

 

Fine-grained auditing

N

Y

 

Enterprise User Security

N Y Enterprise User Security is an EE feature for directory-based management of database users. It does require a corresponding Oracle Identity Management Directory Services Plus to be licensed. Usage of Enterprise User Security with Oracle Datbase strong authentication (PKI Kerberos) no longer requires Oracle Advanced Security to be licensed.

Real Application Security

N

Y

 

Redaction

N

Y

Requires Oracle Advanced Security

Privilege Analysis

N

Y

Requires Data vault option

Transparent Sensitive Data Protection

N

Y

 

Virtual Private Database

N

Y

 

Development Platform

     

SQLJ

Y

Y

Requires Oracle Programmer

Oracle Developer Tools for Visual Studio .NET

Y

Y

Windows only

Microsoft Distributed Transaction Coordinator support

Y

Y

Windows only

Active Directory integration

Y

Y

Windows only

Native .NET Data Provider—ODP.NET

Y

Y

Windows only

.NET Stored Procedures

Y

Y

Windows only

Manageability

     

Oracle Cloud Management Pack for Oracle Database

N

Y

Extra cost option

Oracle Data Masking Pack 

N

Y

Extra cost option

Oracle Database Lifecycle Management Pack for Oracle database

Nhttps://www.cndba.cn/cndba/dave/article/2980

Y

Extra cost option

Oracle Diagnostic Pack

N

Y

Extra cost optionhttps://www.cndba.cn/cndba/dave/article/2980

Oracle Tuning Pack

N

Y

Extra cost option, also requires the Diagnostic Pack

Oracle Real Application Testing

N

Y

Extra cost option

Database Resource Manager

N

Y

 

I/O Resource Management

N

N

 

Instance Caging

Yhttps://www.cndba.cn/cndba/dave/article/2980

Y

 

SQL Plan Management

N

Y

 

SQL Tuning sets

N

Y

SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces.
Rapid Home Provisioning N Y When deployed across multiple clusters, requires Lifecycle Management Pack on targets

VLDB, Data Warehousing, Business Intelligence

     

Oracle Partitioning

N

Y

Extra cost option

Oracle OLAP

N

Y

Extra cost option

Oracle Advanced Analytics

N

Y

Extra cost optionhttps://www.cndba.cn/cndba/dave/article/2980

Oracle Advanced Compression

N

Y

Extra cost option

Advanced Index Compression

N

Y

Requires the Advanced Compression option

Prefix Compression ( Key Compression)

N

Y

 

Hybrid Columnar Compression

N

Y

Requires  ZFS, Axiom or FS1 storage

Hybrid Columnar Compression Row-Level Locking

N

Y

https://www.cndba.cn/cndba/dave/article/2980

Requires ZFS or FS1 storage, and the Advanced Compression optionhttps://www.cndba.cn/cndba/dave/article/2980

Heat Map

Nhttps://www.cndba.cn/cndba/dave/article/2980

Y

Requires the Advanced Compression option

Automatic Data optimization N Y Requires the Advanced Compression option
Basic Table Compression N Y  

Deferred Segment Creation

N

Y

 

Bitmapped index, bitmapped join index, and bitmap plan conversions

N

Y

 

Parallel query/DML

N

Y

 

Parallel statistics gathering

N

Y

 

Parallel index build/scans

N

Y

 

Parallel Data Pump Export/Import

N

Y

 

In-memory Parallel Execution

N

Y

 

Parallel Statement Queuing

N

Y

 

Parallel capture and apply via XStream

N

Y

 

Transportable tablespaces, including cross-platform and Full Transportable export and import

N

Y

Import of transportable tablespaces supported into SE, SE1, and EE

Summary management—Materialized View Query Rewrite

N

Y

 

Integration

     

Basic Replication

Y

Y

SE2 read-only, updateable materialized view

Oracle Streams

Y

Y

SE2: no capture from redo

Database Gateways

Y

Y

Separate product license

Messaging Gateway

N

Y

 

Sharded Queues

N

Y

Requires the Oracle Partitioning option

Networking

     

Oracle Connection Manager

N

Y

Available via a custom install of the Oracle Database client, usually installed on a separate machine

Infiniband Support

N

Y

 

Network Compression

N

Y

Requires the Advanced compression option

Network Encryption (SSL/TLS)

Y

Y

 

Spatial and Graph Data

     

Oracle Spatial and Graph

N

Y

Extra cost option

Graph and Semantic Technologies (RDF/OWL)

N

Y

Requires the Oracle Spatial and Graph option and the Oracle Partitioning option

Parallel spatisl index builds N Y  
Multimaster replication of SDO_GEOMETRY objects N Y Single master/materialized view replication for SDO_GEOMETRY objects is supported

Parallel spatial indexes

N

Y

Requires Oracle Partitioning option

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 2091
    原创
  • 2
    翻译
  • 503
    转载
  • 176
    评论
  • 访问:5042869次
  • 积分:3762
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ