Oracle Enterprise edition (EE), standard edition (SE), and express (XE) Features list Oracle Tips by Burleson Consulting January 17, 2008

Oracle currently has three main "Editions" of the Oracle database, each with different features and prices:

• Oracle Enterprise Edition (EE) - Oracle EE contains most of the robust features required by large Oracle shops.
   

• Oracle Standard Edition (SE) - Oracle SE contains the basic database management functions for small and medium-sized shops.
   

• Oracle Express (XE)   - Oracle Express contain some DBA features.

When choosing the appropriate Oracle edition for your shop you must recognize those database features that you want.  There are many features of Oracle Enterprise Edition (EE) that are not available to Oracle Standard Edition One (SE).  These Oracle Enterprise Edition Features not available in Oracle Standard Edition One include:

• Advanced queuing
• Analytical functions (rank, moving average)
• Bitmap indexes
• Export transportable tablespaces
• Fast-start fault recovery
• Incremental backup & recovery
• Materialized Views - Pre-summarize data and pre-join tables
• Online index build
• Oracle advanced Security:
• Oracle connection manager (CMAN)
• Oracle Data Guard - Automated standby/failover database
• Oracle Parallel Query (OPQ) - Get fast large-table full-table scans
• Oracle partitioning - For database over 100 gigabytes
• Oracle Replication - Multi-master replication and database links
• Oracle Streams - High-speed system replication and failover software.
• Parallel backup & recovery
• Parallel DML
• Parallel index rebuilding
• Parallel index scans
• SQL Optimizer plan stability - Freeze Oracle execution plans
• Transparent Application Failover (TAF)

Add-on Oracle Options:

In addition, Oracle offers many extra-cost database features that you can buy independently from the Oracle database edition.  These include:

• Oracle Real Application Clusters - RAC is the Oracle flagship software for scalability and high availability.
   

• Oracle OLAP - Online Analytical processing for the Oracle Data Warehouse.
   

• Oracle Data Mining - Advanced artificial intelligence for finding hidden data correlations.
   

• Oracle Tuning Pack - Online tools for tuning the Oracle database.
   

• Oracle Change Management Pack - Version control and change auditing.
   

Oracle XE Features

These features are not included with Oracle Database XE:

• Advanced Security Option
• interMedia
• Messaging Gateway
• Oracle Change Management Pack
• Oracle Clusterware
• Oracle Configuration Management Pack
• Oracle Connection Manager
• Oracle Data Guard
• Oracle Data Mining
• Oracle Diagnostic Pack
• Oracle Enterprise Manager
• Oracle Fail Safe
• Oracle Label Security
• Oracle Names
• Oracle OLAP
• Oracle Partitioning
• Oracle Real Application Clusters
• Oracle Spatial
• Oracle Streams (Apply process only)
• Oracle Tuning Pack
• Oracle Workflow
• Oracle Workspace Manager
• Ultra Search

If you like Oracle tuning, you might enjoy my book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Is your RAC database Healthy? Get the experts at Burleson Consulting to conduct a two day RAC health check and ensure the health of your RAC database.  Why guess?  Have your RAC database certified by experienced RAC experts.