Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







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




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.

Oracle Grid and Real Application Clusters

See working examples of Oracle Grid and RAC in the book Oracle Grid and Real Application Clusters.

Order directly from Rampant and save 30%. 



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.