Alessandro Guimarães – Oracle Blog

September 21, 2009

Feature Availability by Edition

Filed under: banco de dados — Tags: , , — agleite @ 1:52 pm

Para complementar o post anterior, uma lista das caracteristicas por “Edition”. Nos treinamentos Oracle 10g Workshop I da Oracle Education, uma das perguntas mais frequentes é :

– Esta feature/caracteristica é Enterprise ou Standard ? .

A tabela abaixo responde este questionamento. Vale para Oracle 10g R2

Feature/Option SE1 SE EE Notes
High Availability
Oracle Fail Safe Y Y Y Windows only
Oracle Data Guard—Redo Apply N N Y
Oracle Data Guard—SQL Apply N N Y
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 ALTER TABLEMOVE ONLINE operations
Online table redefinition N N Y Using the DBMS_REDEFINITION package
Duplexed backup sets N N Y
Incremental backup and recovery Y Y Y SE1/SE: no optimized incremental backup
Unused block compression in backups N N Y
Block-level media recovery N N Y
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 Query N N Y
Scalability
Oracle Real Application Clusters N Y Y Extra cost with EE, included with SE
Automatic Workload Management N Y Y Requires RAC
Performance
In-Memory Database Cache N N Y Extra cost option
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
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
Database Resource Manager 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 Quality and Profiling N N Y Extra cost option
Oracle Data Watch and Repair Connector N N Y Extra cost option
Data Compression N N Y
Bitmapped index and bitmapped join index 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
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
Transparent Gateways Y Y Y Extra cost option
Oracle Streams N N Y SE1/SE: apply only
Messaging Gateway N N Y
Advanced Replication N N Y Multi-master replication
Networking
Oracle Connection Manager N N Y
Infiniband Support N N Y
Content Management
Oracle Spatial N N Y Extra cost option
Oracle Content Database Suite N N Y Extra cost option
Oracle Records DB N N Y Extra cost option

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: