| 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 |
|
|
|
|
Total Recall
Provides secure, efficient, easy-to-use and application-transparent solution for long-term storage of historical data. |
|
|
|
Option |
Active Data Guard
Enhances disaster protection investments by offloading resource intensive operations to a single physical standby database, enhancing overall quality of service. |
|
|
|
Option |
Fail Safe
Configure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server. |
|
|
|
|
Flashback Query
Recover older versions of data without complex, time-consuming operations. |
|
|
|
|
Flashback Table, Database and Transaction Query
Diagnose and undo errors to reduce recovery time. |
|
|
|
|
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. |
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 |
|
|
|
|
Real Application Clusters
Run any packaged or custom application unchanged across multiple connected, or "clustered," servers. |
|
|
|
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 |
|
|
|
| Security |
|
|
|
|
Oracle Database Vault
Restricts super-user and privileged-user access across applications and data. |
|
|
|
Option |
Oracle Audit Vault
Automates the collection and analysis of audit data from multiple systems, turning audit data into a key security resource. |
Oracle Audit Vault is its own product that works with each database edition |
Oracle Advanced Security
Address privacy and compliance requirements. |
|
|
|
Option |
Oracle Label Security
Provides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. |
|
|
|
Option |
Secure Application Roles
Enable roles only after a user passes any number of security checks. |
|
|
|
|
Virtual Private Database
Enforce data security and privacy with customizable, policy-based access control down to the row level. |
|
|
|
|
Fine-Grained Auditing
Allows highly focused auditing with almost no 'background noise'. |
|
|
|
|
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. |
|
|
|
|
| Application Development |
|
|
|
|
Oracle SQL Developer
Graphical tool that enhances productivity and simplifies database development tasks. |
|
|
|
|
Application Express
Develop and deploy fast, secure applications with a rapid web application development tool. |
|
|
|
|
Java Support
Grid-enable databases through Web Services. |
|
|
|
|
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. |
|
|
|
|
PL/SQL and Java Server Pages
Utilize a server-side Java and stored procedural language; secure, portable and seamless with SQL. |
PL/SQL only |
|
|
|
Comprehensive Microsoft .Net Support, OLE DB, ODBC
Support multiple Windows data access methods. |
|
|
|
|
| Manageability |
|
|
|
|
Real Application Testing
Reduces risk and costs of adopting new technologies, whether it's operating systems, servers, or software. |
|
|
|
Option |
Enterprise Manager
Manage and monitor all applications and systems based on the Oracle stack via a single, integrated console. |
|
|
|
|
Automatic Memory Management
Automate management of shared memory used by an Oracle Database instance. |
|
|
|
|
Automatic Storage Management
Consistent storage management interface across all server and storage platforms. |
|
|
|
|
Automatic Undo Management
Monitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions. |
|
|
|
|
| Data Warehousing |
|
|
|
|
Advanced Compression
Compresses all types of data, including structured and unstructured data, to help you use resources more efficiently and lower storage costs. |
|
|
|
Option |
OLAP
Use built-in analytical workspaces for Online Analytical Processing (OLAP). |
|
|
|
Option |
Partitioning
Enables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications. |
|
|
|
Option |
Data Mining
Enables efficient information extraction from the very largest databases and integration with business intelligence applications. |
|
|
|
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. |
|
|
|
|
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. |
|
Core ETL features included |
Core ETL features included |
Enterprise ETL, Data Quality, and Connectors Options available |
| Integration |
|
|
|
|
Oracle Streams
Propagate and manage data, transactions, and events in a data stream either within a database, or from one database to another. |
|
|
|
|
Advanced Queuing
Allow database queues to serve as durable message stores via queue-based publish-subscribe. |
|
|
|
|
Workflow
Support business process-based integration with a complete workflow management system. |
|
|
|
|
Distributed Queries/Transactions
Query or update data on two or more distinct nodes of a distributed database. |
|
|
|
|
| Content Management |
|
|
|
|
XML DB
High-performance, native XML storage and retrieval technology. |
|
|
|
|
Multimedia
Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats. |
|
|
|
|
Text
Build text query applications and document classification applications. |
|
|
|
|
Locator
Manage geospatial data to leverage the business value of location. |
|
|
|
|
Spatial
Support for sophisticated GIS deployments. |
|
|
|
Option |
Secure Enterprise Search
Internet-like search experience to users searching secure content inside the enterprise while protecting sensitive data from unauthorized users. |
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. |
|
|
|
Option |
