Whether you're a lone developer, small and midsize business, or large corporate enterprise, there's an edition of
the world's #1 database tailored to meet your business and technical requirements.
| 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 |
