Key Feature Summary |
Express Edition |
Standard Edition One |
Standard Edition |
Enterprise Edition |
Maximum CPUs |
1 |
2 |
4 |
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  |
|
|
|
|
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.  |
|
|
|
|
Data Guard
Create, maintain, and monitor one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.  |
|
|
|
|
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 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  |
|
|
|
|
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  |
|
|
|
|
Data Compression
Compress data stored in relational tables without impacting query time; reduce disk system costs. |
|
|
|
|
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.  |
|
|
|
|
interMedia
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 |
Oracle 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 |
Oracle Records Database
Comprehensive records management that enables compliance, lowers risk and cost of legal discovery via audit trails, enforcing legal holds, and quick access to vital information.  |
|
|
|
Option |