Oracle 11g Database Enterprise Edition New Features

Oracle Database Tips by Donald Burleson

Features and Options Only Available to Oracle 11g Enterprise Edition

Here is a list of the features and options that can be found in the Oracle 11g Enterprise Edition.  This gives the manager an idea of what features best fit the needs of his/her company and can help in deciding whether the Enterprise Edition or the Standard Edition is the best choice for the company's needs.

• Oracle Data Guard

- Redo Apply, SQL Apply, Snapshot Standby, Network Compression, Active Data Guard

• Rolling upgrades

• Fast-start selectable recovery time

• Online schema reorganization

• Flashback

- Table, Database, Transaction, Transaction Query, Data Archive

• Block-level media recovery

• Block change tracking for faster incremental backups

• Parallel backup and recovery

• Fast RMAN Compression (ZLIB)

• Point-in-time tablespace recovery

• Trial recovery

• Oracle Advanced and Label Security

• Virtual Private Database

• Fine grained auditing

• New results cache feature

• New Client Side Query Cache

• Change Management and Configuration Management Packs

• Diagnostic and Tuning Packs

• Duplexed backup sets

• Resource Manager

• SQL Plan Management

• Partitioning

• Data Mining

• Direct Load and OLTP Compression

• Bitmapped index and bitmapped join index

• Various Parallel operations

- Query, Statistics gathering, Index build, Index scan, Data Pump, Export/Import

• Data Pump Compression

• Export Transportable tablespace

• Materialized View Query Rewrite

• Asynchronous Change Data Capture

• Full Oracle Streams options

• Messaging Gateway

• Advanced Replication

• Connection Manager

• InfiniBand Support

• Oracle Spatial

Features and Options available to Oracle 11g Standard Edition

Here is a list of the features and options for the Standard Edition so that the manager has a comparison with the Enterprise Edition.

• Basic Standby Database (Manually managed)

• Online system changes

• Flashback Query

• Online Backup and Recovery

• Incremental Backup and Recovery

• Default RMAN Compression (BZIP2)

• Oracle Fail Safe (Windows only)

• Data Recovery Advisor

• Transparent Application Failover

• Real Application Clusters

• Oracle Clusterware

• Automatic Workload Management

• Encryption toolkit

• Java support

• Database Web services

• SQLJ

• JDBC drivers

• XML support in the database

• Xquery

• Objects and extensibility

• Various PL/SQL features

- Regular Expressions, Stored procedures, Triggers, Server pages, native compile

• Java Server Pages and Java native compilation

• Various Microsoft items

- Developer Tools for Visual Studio .Net, DTC support, Active Directory integration, ODP.Net, .Net stored procedures

• 64-bit Itanium support

• Globalization support

• Application Express

• SQL*Plus and SQL Developer

• Fast Lightweight Server Install

• Easy Client Install

• Oracle Enterprise Manager - Database Control

• Automatic

- memory management, storage management, undo management, statistics management

• RMAN

• Backup to Flash Recovery Area

• Server generated Alerts

• Application Tracing

• Resumable Space Allocation

• SQL Analytic functions

• Function-based indexes

• Basic Data Pump Export/Import

• Import Transportable Tablespace

• Star query transformation (b-tree only)

• Sample scan

• Summary Management - Materialized View creation and refresh

• Direct Path Load API

• External tables

• SQL Model

• Synchronous Change Data Capture

• Oracle Streams Apply only

• Oracle Streams Advanced Queuing

• Basic Replication

• Distributed queries/transactions

• Job Scheduler

• External procedures

• Generic connectivity

• Transparent Gateways

• Connection polling

• Oracle Locator

• Oracle Workspace Manager

• MultiMedia

• Oracle Text

• SecureFiles

• Database event triggers

• Various column operations

- drop, rename, constraint, virtual

• Amazing Invisible Indexes

• Index-organized table

• Instead-of triggers

• LOB support

• LogMiner

• Multiple block size support

• Temporary tables

That was a long list!  This information might save one's company $50,000 in Oracle licensing costs.  For larger sites, it could even save the company millions of dollars.  The great thing about Oracle 11g Standard Edition is that it is easy to upgrade to Enterprise Edition when necessary.

Whether Standard Edition is an option or not, many enterprises are showing interest in major data or database consolidation. For example, dozens of instances residing on several hosts or servers are merged into a large database. With a powerful server platform, abundant memory, and ample processor resources, it is common to establish a very large database (VLDB) that can accumulate terabytes of data.  This license can be called scale-in.

Oracle VLDB has proven to be a good cost saving solution.  Oracle 11g Enterprise Edition offers dynamic parallel processing features that can offer significant performance time improvements.  This approach provides:

• Reduced TCO in terms of licensing, staffing, and consulting fees

• Improved availability with the focus on fewer databases

• Higher security

• Centralized backup and archive

RAC with Grid is an ideal solution to take advantage of these developments. RAC supports VLDB databases for data consolidation and large data warehousing databases. Even in a packaged application environment, as in SAP or PeopleSoft, there is a tendency towards consolidating the databases to provide lower cost and better administrative flexibility. 

With the power of processors today, reducing a corporation's database server footprint to be a tenth of what it was is a real possibility.  Virtual machines are a big part of enterprise server consolidation efforts.  Oracle VM is a less known product in the Virtual Machine marketplace but is interesting because it is fully supported for various Oracle products.  See MOSC Doc 464754.1 for the latest information about RAC on Oracle VM.

Enterprise Features not available in Standard Edition

Enterprise Edition Features
11g new feature not in SE
12c new feature not in SE
Consolidation	Detect?	SE 10g	SE 11g	SE 12c
Multitenant	Y			N
Storage snapshot optimization				N
High Availability	Detect?	SE 10g	SE 11g	SE 12c
Application Continuity				N
RAC One Node	Y			N
Data Guard - redo apply (physical standby)	Y	N	N	N
Data Guard - SQL apply (logical standby)	Y	N	N	N
Data Guard - Snapshot Standby	Y		N	N
Active Data Guard	Y		N	N
Data guard network compression			N
Rolling Upgrades		N	N	N
Rolling upgrades - using active data guard				N
Fast start selectable recovery time		N
Fast start fault recovery			N	N
Online index rebuild			N	N
IOT reorganization			N	N
Duplexed backup sets				N
Block change tracking for fast incremental backup				N
Unused block compression in backups				N
Block level media recovery				N
Lost write protection				N
Automatic block repair				N
dbms_redefinition		N	N
Flashback table		N	N	N
Flashback Database	Y	N	N	N
Flashback transaction			N	N
Optimization for Flashback Data Archive				N
Flashback transaction query		N	N	N
Flashback Data Archive (total recall)			N
Online datafile move				N
Transaction guard				N
Cross platform backup and recovery				N
Global Data Services				N
Block-level Media Recovery		N	N	N
Unused block compression in backups			N	N
Parallel backup & recovery		N	N	N
Fast RMAN Compression (ZLIB)			N	N
Point-in-time tablespace recovery		N	N	N
Trial recovery		N	N	N
Recovering tables from RMAN backups				N
Scalability	Detect?	SE 10g	SE 11g	SE 12c
Real Application Clusters (RAC)	Y	Y	Y	Y
Quality of service management				N
Support for Exadata storage server			N	N
In memory database cache			N
Concurrent execution of UNION branches				N
In memory column store	Y			N
Fault tolerant in memory column store				N
In memory aggregation				N
Attribute clustering				N
Zone maps	Y			N
Adaptive execution plans	Y			N
Security	Detect?	SE 10g	SE 11g	SE 12c
Advanced Security option	Y	N	N	N
Database vault	Y			N
Oracle Label Security	Y	N	N	N
Enterprise security	Y			N
Data Masking Pack	Y		N
Virtual Private Database	Y	N	N	N
Fine Grained Auditing	Y	N	N	N
Privilege analysis				N
Real Application Security				N
Redaction				N
Transparent sensitive data protection				N
Secure Application Role			N
Performance	Detect?	SE 10g	SE 11g	SE 12c
PL/SQL function result cache			N	N
Times Ten application-tier database cache				N
Database smart flash cache	Y			N
Client-side query cache	Y		N	N
Query result cache	Y			N
Manageability	Detect?	SE 10g	SE 11g	SE 12c
Change Management Pack	Y	N	N
Configuration Management Pack	Y	N	N
Cloud management pack	Y			N
Data Masking Pack and sub-setting	Y			N
Lifecycle management pack	Y			N
Diagnostic Pack	Y	N	N	N
Tuning Pack	Y	N	N	N
Provisioning and Patch automation pack	Y		N
Duplexed backup sets		N	N
Database Resource Manager		N	N	N
Instance caging	Y			N
SQL Plan management	Y		N	N
Rapid Home provisioning				N
VLDB, Data Warehousing, BI	Detect?	SE 10g	SE 11g	SE 12c
Partitioning option	Y	N	N	N
OLAP option	Y	N	N	N
Advanced analytics	Y		N	N
Advanced compression	Y			N
Advanced index compression	Y			N
Prefix compression (key compression)				N
Hybrid columnar compression				N
Exadata flash cache compression				N
Heat maps				N
automatic data optimization				N
basic table compression	Y			N
Deferred segment creation				N
Direct Load data compression			N
OLTP compression			N
Data Mining Option		N
Data Compression	Y	N
Bitmap index & bitmap join index	Y	N	N	N
Parallel query/ DML	Y (partial)	N	N	N
Parallel CBO statistics gathering		N	N	N
Parallel index builds/scans		N	N	N
Parallel data pump export/import		N	N	N
In-memory parallel execution				N
Parallel statement queueing				N
Parallel capture and apply via Xstream				N
Data Pump Compression			N
Export transportable tablespaces	Y		N
Transportable tablespaces	Y	N		N
Materialized views - query rewrite	Y	N	N	N
Asynchronous Data Change Capture		N	N
Query rewrite cache			N
Integration	Detect?	SE 10g	SE 11g	SE 12c
Oracle Streams	Y	N	Y	Y
Messaging gateway		N	N	N
Sharded queues	Y			N
Advanced Replication	Y	N	N	N
Distributed queries	Y	N	Y
Networking	Detect?	SE 10g	SE 11g	SE 12c
Connection Manager (CMAN)		N	N	N
infiniband Support		N	N	N
Spatial and Graph Data	Detect?	SE 10g	SE 11g	SE 12c
Oracle Spatial	Y	N	N	N
Semantic Technologies (RDF/OWL)			N	N
Network Compression				N
Network encryption (SSL/TLS)				N
Parallel spatial index builds				N
Multimaster replication of SDO_GEOMETRY objects				N
Partitioned spatial indexes				N

Conclusion

Oracle RAC provides a scalable and highly available data storage platform.  Multi-instances and multiple nodes make RAC a powerful database platform. Most applications can use this multi-node clustered database without any code modification. This chapter also listed the options and features for both Oracle 11g Standard Edition and Enterprise Edition that helps one make a decision on which package is ideal for one's situation.