Contact us
* required fields










Captcha image

Can't read the image? Click here to refresh.

Thanks!

Thanks for contacting us. We will get in touch with you soon!

Close this window



Oracle Database is available in five editions, each suitable for different development and deployment scenarios. Oracle also offers several database options, packs, and other products that enhance the capabilities of Oracle Database for specific purposes. This section describes the Oracle Database editions.



    Feature/Option Oracle Database Standard Edition One delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications. From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition One includes all the facilities necessary to build business-critical applications. Oracle Database Standard Edition delivers the unprecedented ease of use, power, and performance of Standard Edition One, with support for larger machines and clustering of services with Oracle Real Application Clusters (Oracle RAC). Oracle RAC is not included in the Standard Edition of releases prior to Oracle Database 10g, nor is it an available option with those earlier releases. Oracle Database Enterprise Edition provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications. Oracle Database Enterprise Edition contains all of the components of Oracle Database.                     Notes

    High Availability
    Oracle Fail Safe                     Y                     Y                     Y     Windows only
    Oracle RAC One Node                     N                     N                     Y     Extra cost option
    Oracle Data Guard-Redo
     Apply
                    N                     N                     Y                     -
    Oracle Data Guard-SQL
     Apply
                    N                     N                     Y                     -
    Oracle Data Guard-
    Snapshot Standby
                    N                     N                     Y                     -
    Oracle Active Data Guard                     N                     N                     Y     Extra cost option
    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 TABLE ...
     MOVE ONLINE operations
    Online table redefinition                     N                     N                     Y     Using the
    DBMS_REDEFINITION
     package
    Duplexed backup sets                     N                     N                     Y                     -
    Block change tracking
    for fast incremental backup
                    N                     N                     Y                     -
    Online table redefinition                     N                     N                     Y     Using the
    DBMS_REDEFINITION
     package
    Online table redefinition                     N                     N                     Y     Using the
     DBMS_REDEFINITION
     package
    Unused block compression
     in backups
                    N                     N                     Y                     -
    OBlock-level media
    recovery
                    N                     N                     Y                     -
    Lost Write Protection                     N                     N                     Y                     -
    Automatic Block Repair                     N                     N                     Y     Requires Oracle Active
     Data Guard option
    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                     N                     N                     Y                     -
    Flashback Transaction
     Query
                    N                     N                     Y                     
    Optimization for Flashback
     Data Archive history tables
                    N                     N                     Y

For releases earlier than Oracle Database 11g Release 2 (11.2.0.4): You must license the Oracle Advanced Compression option to use Flashback Data Archive (formerly known as Total Recall).

Beginning with Oracle Database 11g Release 2 (11.2.0.4): You must license the Oracle Advanced Compression option to use Optimization for Flashback Data Archive history tables. Basic Flashback Data Archive-without history table optimization-is available in all editions.

    Scalability
    Oracle Real Application
     Clusters
                    N                     Y                     Y     Oracle Real Application
     Clusters
    Automatic Workload
    Management
                    N                     Y                     Y     Requires Oracle Real
    Application Clusters
    Quality of Service
    Management
                    N                     N                     Y     Requires Oracle Real
     Application Clusters
    Performance
    Client Side Query Cache                     N                     N                     Y                     -
    Query Results Cache                     N                     N                     Y                     -
    PL/SQL Function Result
     Cache
                    N                     N                     Y                     -
    TimesTen Application-Tier
     Database Cache
                    N                     N                     Y     Extra cost option
    Database Smart Flash
     Cache
                    N                     N                     Y     Solaris and Oracle
    Linux only
    Support for Oracle Exadata
     Storage Server Software
                    N                     N                     Y                     -
    Security
    Oracle Advanced Security                     N                     N                     Y     Extra cost option
    Oracle Database Vault                     N                     N                     Y     Extra cost option
    Oracle Label Security                     N                     N                     Y     Extra cost option
    Enterprise User Security                     N                     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 Database strong authentication (PKI, Kerberos) no longer requires Oracle Advanced Security to be licensed.
    Fine-grained auditing                     N                     N                     Y                     -
    Real Application Security                     N                     N                     Y                     -
    Secure External Password
    Store
                    N                     N                     Y                     -
    Virtual Private Database                     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 Diagnostics
     Pack
                    N                     N                     Y     Extra cost option
    Oracle Tuning Pack                     N                     N                     Y     Extra cost option,
     also requires the
    Diagnostics Pack
    Oracle Provisioning and
    Patch Automation Pack
                    N                     N                     Y     Extra cost option
    Oracle Real Application
     Testing
                    N                     N                     Y     Extra cost option
    Database Resource
    Manager
                    N                     N                     Y                     -
    Instance Caging                     N                     N                     Y                     -
    SQL Plan Management                     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 Advanced Analytics                     N                     N                     Y     Extra cost option

Oracle R Enterprise Server is limited to operation on Oracle Linux 5 Update 6 or higher and Red Hat Enterprise Linux 5 Update 6 or higher

    Oracle Advanced
    Compression
                    N                     N                     Y     Extra cost option
    Key Compression                     N                     N                     Y                     -
    Hybrid Columnar
    Compression
                    N                     N                     Y     Requires Exadata, ZFS,
     or Pillar Axiom 600 storage
    Exadata Flash Cache
     Compression
                    N                     N                     Y     Requires the Advanced
    Compression option
    Basic Table Compression                     N                     N                     Y                     -
    Deferred Segment Creation                     N                     N                     Y                     -
    Bitmapped index,
     bitmapped join index,
     and bitmap plan
     conversions
                    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                     -
    In-memory Parallel
     Execution
                    N                     N                     Y                     -
    Parallel Statement Queuing                     N                     N                     Y                     -
    Parallel capture and
    apply via XStream
                    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
    Advanced Replication                     N                     N                     Y     Multi-master replication
    Oracle Streams                     Y Y                                         Y     SE1/SE: no capture
    from redo
    Database Gateways                     Y                     y                     Y     Separate product license
    Messaging Gateway                     N                     N                     Y                     -
    Networking
    Oracle Connection Manager                     N                     N                     Y Available via a custom install of the Oracle Database client, usually installed on a separate machine

See "Oracle Connection Manager" for more information
    Infiniband Support                     N                     N                     Y                     -
    Content Management
    Oracle Spatial and Graph                     N                     N                     Y     Extra cost option
    Semantic Technologies
     (RDF/OWL)
                    N                     N                     Y Requires the Oracle Spatial and Graph option and the Oracle Partitioning option
    Spatial and Location Data
    Parallel spatial index
     builds
                    N                     N                     Y                     -
    Multimaster replication of
     SDO_GEOMETRY objects
                    N                     N                     Y Single master/materialized view replication for SDO_GEOMETRY objects is supported with both Standard Edition and Enterprise Edition
    Partitioned spatial indexes                     N                     N                     Y     Requires the Oracle
    Partitioning option