Key Feature Summary

Standard 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