Oracle Database 11g Editions

Key Feature Summary	Express Edition 10g	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 Create and operate database clusters with a set of common, built-in clustering services.
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 from unauthorized users. Read More	Oracle Secure Enterprise Search is its own product that works with each database edition
Oracle Content Database Ready-to-use Web services to seamlessly integrate content management capabilities into the business processes. Read More				Option