| 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 MORE  | | | | |
| Fail SafeConfigure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server. MORE | | | | |
| Flashback QueryRecover older versions of data without complex, time-consuming operations. MORE | | | | |
| Flashback Table, Database and Transaction QueryDiagnose and undo errors to reduce recovery time. MORE | | | | |
| Data GuardCreate, maintain, and monitor one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions. MORE | | | | |
| Scalability MORE | | | | |
| Real Application ClustersRun any packaged or custom application unchanged across multiple connected, or "clustered," servers. 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 | | | |
| Security MORE | | | | |
| Oracle Database VaultRestricts super-user and privileged-user access across applications and data. MORE | | | | Option |
| Oracle Advanced SecurityAddress privacy and compliance requirements. MORE | | | | Option |
| Oracle Label SecurityProvides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. MORE | | | | Option |
| Secure Application RolesEnable roles only after a user passes any number of security checks. MORE | | | | |
| Virtual Private DatabaseEnforce data security and privacy with customizable, policy-based access control down to the row level. MORE | | | | |
| Fine-Grained AuditingAllows highly focused auditing with almost no 'background noise'. MORE | | | | |
| Proxy AuthenticationDetects and authenticates users connecting through a middle-tier application. | | | | |
| Data Encryption ToolkitProtect vital data by providing an extra layer of protection for data on storage media. MORE | | | | |
| Application Development MORE | | | | |
Oracle SQL Developer
Graphical tool that enhances productivity and simplifies database development tasks. MORE | | | | |
Application Express
Develop and deploy fast, secure applications with a rapid web application development tool. MORE | | | | |
Java Support
Grid-enable databases through Web Services. 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. MORE | | | | |
PL/SQL and Java Server Pages
Utilize a server-side Java and stored procedural language; secure, portable and seamless with SQL. MORE | PL/SQL only | | | |
Comprehensive Microsoft .Net Support, OLE DB, ODBC
Support multiple Windows data access methods. MORE | | | | |
| Manageability MORE | | | | |
| Enterprise ManagerManage and monitor all applications and systems based on the Oracle stack via a single, integrated console. MORE | | | | |
Automatic Memory Management
Automate management of shared memory used by an Oracle Database instance. MORE | | | | |
Automatic Storage Management
Consistent storage management interface across all server and storage platforms. MORE | | | | |
Automatic Undo Management
Monitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions. | | | | |
Server Managed Backup and Recovery
Simplify, automate, and improve backup and recovery performance with Oracle Recovery Manager (RMAN). | | | | |
| Data Warehousing MORE | | | | |
Data Compression
Compress data stored in relational tables without impacting query time; reduce disk system costs. | | | | |
| OLAPUse built-in analytical workspaces for Online Analytical Processing (OLAP). MORE | | | | Option |
| PartitioningEnables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications. MORE | | | | Option |
| Data MiningEnables efficient information extraction from the very largest databases and integration with business intelligence applications. 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 ManagementUnderstand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept. MORE | | | | |
Summary Management - Materialized View Query Rewrite
Automatically recognizing materialized view usage to satisfy requests. | | | | |
| Integration MORE | | | | |
Oracle Streams
Propagate and manage data, transactions, and events in a data stream either within a database, or from one database to another. MORE | | | | |
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 MORE | | | | |
XML DB
High-performance, native XML storage and retrieval technology. MORE | | | | |
interMedia
Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats. MORE | | | | |
Text
Build text query applications and document classification applications. MORE | | | | |
Locator
Manage geospatial data to leverage the business value of location. MORE | | | | |
Spatial
Support for sophisticated GIS deployments. MORE | | | | Option |
