Oracle Database features Vs Editions   Aug 2, 2009

This is an important table that show feature support for the various Oracle Editions.

It applied to Oracle 11g and taken from Oracle website

http://www.oracle.com/database/product_editions.html

 

 

   

 
Key Feature Summary Express Edition
10
g
Standard Edition One Standard Edition Enterprise Edition
Maximum 1 CPU 2 Sockets 4 Sockets No Limit
RAM 1GB OS Max OS Max OS Max
Database Size 4GB No Limit No Limit No Limit
Windows
Linux
Unix  
64 Bit Support  
High Availability  Read More        
Total Recall
Provides secure, efficient, easy-to-use and application-transparent solution for long-term storage of historical data. Read More
      Option
Active Data Guard
Enhances disaster protection investments by offloading resource intensive operations to a single physical standby database, enhancing overall quality of service. Read More
      Option
Fail Safe
Configure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server. Read More
 
Flashback Query
Recover older versions of data without complex, time-consuming operations. Read More
Flashback Table, Database and Transaction Query
Diagnose and undo errors to reduce recovery time. Read More
     
Oracle Secure Backup
Secure, high performance tape backup management for the Oracle Database and heterogenous file systems reducing the cost and complexity of networked data protection. Read More
Oracle Secure Backup is its own product that works with each database edition
Server Managed Backup and Recovery
Simplify, automate, and improve backup and recovery performance with Oracle Recovery Manager (RMAN).
 
Scalability  Read More        
Real Application Clusters
Run any packaged or custom application unchanged across multiple connected, or "clustered," servers. Read More
    Option
Integrated Clusterware
Built-in clustering services to protect any Oracle application or any other kind of application within a cluster.
 
Automatic Workload Management
Route service connection requests to appropriate server with lowest load; on failure, automatically reallocate surviving servers to services.
   
Java, PL/SQL Native Compilation
Write stored procedures deployed in the database in both Java and PL/SQL.
PL/SQL only
In-Memory Database Cache
Increases responsiveness and throughput by caching frequently used data in memory. Read More
      Option
Security  Read More        
Oracle Database Vault
Restricts super-user and privileged-user access across applications and data. Read More
      Option
Oracle Audit Vault
Automates the collection and analysis of audit data from multiple systems, turning audit data into a key security resource. Read More
Oracle Audit Vault is its own product that works with each database edition
Oracle Advanced Security
Address privacy and compliance requirements. Read More
      Option
Oracle Label Security
Provides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. Read More
      Option
Secure Application Roles
Enable roles only after a user passes any number of security checks. Read More
     
Virtual Private Database
Enforce data security and privacy with customizable, policy-based access control down to the row level. Read More
     
Fine-Grained Auditing
Allows highly focused auditing with almost no 'background noise'. Read More
     
Proxy Authentication
Detects and authenticates users connecting through a middle-tier application.
 
Data Encryption Toolkit
Protect vital data by providing an extra layer of protection for data on storage media. Read More
Application Development  Read More        
Oracle SQL Developer
Graphical tool that enhances productivity and simplifies database development tasks. Read More
Application Express
Develop and deploy fast, secure applications with a rapid web application development tool. Read More
Java Support
Grid-enable databases through Web Services. Read More
 
Comprehensive XML Support
Store and retrieve XML natively with support for the W3C XML data model; use standard access methods for navigating and querying XML. Read More
PL/SQL and Java Server Pages
Utilize a server-side Java and stored procedural language; secure, portable and seamless with SQL. Read More
PL/SQL only
Comprehensive Microsoft .Net Support, OLE DB, ODBC
Support multiple Windows data access methods. Read More
Manageability  Read More        
Real Application Testing
Reduces risk and costs of adopting new technologies, whether it's operating systems, servers, or software. Read More
      Option
Enterprise Manager
Manage and monitor all applications and systems based on the Oracle stack via a single, integrated console. Read More
 
Automatic Memory Management
Automate management of shared memory used by an Oracle Database instance. Read More
Automatic Storage Management
Consistent storage management interface across all server and storage platforms. Read More
 
Automatic Undo Management
Monitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions.
Data Warehousing  Read More        
Advanced Compression
Compresses all types of data, including structured and unstructured data, to help you use resources more efficiently and lower storage costs. Read More
      Option
OLAP
Use built-in analytical workspaces for Online Analytical Processing (OLAP). Read More
      Option
Partitioning
Enables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications. Read More
      Option
Data Mining
Enables efficient information extraction from the very largest databases and integration with business intelligence applications. Read More
      Option
Transportable Tablespaces, Including Cross-Platform
Transport a set of tablespaces from one database to another, or from one database to itself.
     
Star Query Optimization
Join a fact table and a number of dimension tables.
PL/SQL only
Information Lifecycle Management
Understand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept. Read More
     
Summary Management - Materialized View Query Rewrite
Automatically recognizing materialized view usage to satisfy requests.
     
Oracle Warehouse Builder
Transforms disparate raw data into high-quality information optimized for business reporting and analytics. Read More
  Core ETL features included Core ETL features included Enterprise ETL, Data Quality, and Connectors Options available
Integration  Read More        
Oracle Streams
Propagate and manage data, transactions, and events in a data stream either within a database, or from one database to another. Read More
     
Advanced Queuing
Allow database queues to serve as durable message stores via queue-based publish-subscribe.
Distributed Queries/Transactions
Query or update data on two or more distinct nodes of a distributed database.
Content Management  Read More        
XML DB
High-performance, native XML storage and retrieval technology. Read More
Multimedia
Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats. Read More
 
Text
Build text query applications and document classification applications. Read More
Locator
Manage geospatial data to leverage the business value of location. Read More
Spatial
Support for sophisticated GIS deployments. Read More
      Option
Secure Enterprise Search
Internet-like search experience to users searching secure content inside the enterprise while protecting sensitive data