| 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 INFORMATION |
|
|
|
|
Fail
Safe
Configure, verify Windows clusters and automatically
fail over fast and accurately through high availability
software integrated with Microsoft Cluster Server. MORE INFORMATION  |
|
 |
 |
 |
Flashback
Query
Recover older versions of data without complex, time-consuming
operations. MORE INFORMATION  |
 |
 |
 |
 |
Flashback
Table, Database and Transaction Query
Diagnose and undo errors to reduce recovery time. MORE INFORMATION  |
|
|
|
 |
Data
Guard
Create, maintain, and monitor one or more standby
databases to protect enterprise data from failures, disasters,
errors, and corruptions. MORE INFORMATION  |
|
|
|
 |
Secure,
high performance tape backup management for
the Oracle Database and heterogenous file systems reducing
the cost and complexity of networked data protection. MORE INFORMATION  |
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 MORE INFORMATION  |
|
|
|
|
Real
Application Clusters
Run any packaged or custom application unchanged across
multiple connected, or "clustered," servers.MORE INFORMATION |
|
|
 |
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 INFORMATION |
|
|
|
|
Oracle
Database Vault
Restricts super-user and privileged-user access
across applications and data. MORE INFORMATION  |
|
|
|
Option |
Oracle
Advanced Security
Address privacy and compliance requirements.MORE INFORMATION  |
|
|
|
Option |
Oracle
Label Security
Provides out-of-the-box row-level security. Compare user
security clearances with data classification labels attached
to data rows. MORE INFORMATION  |
|
|
|
Option |
Secure
Application Roles
Enable roles only after a user passes any number of security
checks. MORE INFORMATION  |
|
|
|
 |
Virtual
Private Database
Enforce data security and privacy with customizable,
policy-based access control down to the row level. MORE INFORMATION  |
|
|
|
 |
Fine-Grained
Auditing
Allows highly focused auditing with almost no 'background
noise'. MORE INFORMATION  |
|
|
|
 |
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. MORE INFORMATION  |
 |
 |
 |
 |
Application Development MORE INFORMATION  |
|
|
|
|
Oracle
SQL Developer
Graphical tool that enhances productivity and
simplifies database development tasks.MORE INFORMATION  |
 |
 |
 |
 |
Application
Express
Develop and deploy fast, secure applications with a rapid
web application development tool. MORE INFORMATION  |
 |
 |
 |
 |
Java
Support
Grid-enable databases through Web Services. MORE INFORMATION  |
|
 |
 |
 |
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 INFORMATION  |
 |
 |
 |
 |
PL/SQL
and Java Server Pages
Utilize a server-side Java and stored procedural language;
secure, portable and seamless with SQL. MORE INFORMATION  |
PL/SQL only |
 |
 |
 |
Comprehensive
Microsoft .Net Support, OLE DB, ODBC
Support multiple Windows data access methods. MORE INFORMATION  |
 |
 |
 |
 |
Manageability MORE INFORMATION |
|
|
|
|
Enterprise
Manager
Manage and monitor all applications and systems based
on the Oracle stack via a single, integrated console. MORE INFORMATION  |
|
 |
 |
 |
Automatic Memory Management
Automate management of shared memory used by
an Oracle Database instance. MORE INFORMATION  |
 |
 |
 |
 |
Automatic Storage Management
Consistent storage management interface across
all server and storage platforms. MORE INFORMATION  |
|
 |
 |
 |
Automatic Undo Management
Monitor configuration of all Oracle systems
for parameter settings, security set-up, storage and
file space conditions. |
 |
 |
 |
 |
Data
Warehousing MORE INFORMATION  |
|
|
|
|
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). MORE INFORMATION  |
|
|
|
Option |
Partitioning
Enables large tables and indexes to be split into smaller,
more manageable components, without requiring changes
to underlying applications. MORE INFORMATION  |
|
|
|
Option |
Data
Mining
Enables efficient information extraction from the very
largest databases and integration with business intelligence
applications. MORE INFORMATION  |
|
|
|
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. MORE INFORMATION  |
|
|
|
 |
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. MORE INFORMATION  |
|
Core ETL features included |
Core ETL features included |
Enterprise ETL, Data Quality, and Connectors
Options available |
Integration MORE INFORMATION |
|
|
|
|
Oracle
Streams
Propagate and manage data, transactions, and events in
a data stream either within a database, or from one database
to another. MORE INFORMATION  |
|
|
|
 |
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 INFORMATION |
|
|
|
|
XML
DB
High-performance, native XML storage and retrieval technology. MORE INFORMATION  |
 |
 |
 |
 |
interMedia
Develop, deploy, and manage traditional, Web, and wireless
applications that include rich media in the most-popular
formats. MORE INFORMATION  |
|
 |
 |
 |
Text
Build text query applications and document classification
applications. MORE INFORMATION  |
 |
 |
 |
 |
Locator
Manage geospatial data to leverage the business value
of location. MORE INFORMATION  |
 |
 |
 |
 |
Spatial
Support for sophisticated GIS deployments.
MORE INFORMATION  |
|
|
|
Option |
Oracle
Secure Enterprise Search
Internet-like search experience to users searching secure
content inside the enterprise while protecting sensitive
data from unauthorized users. MORE INFORMATION  |
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. MORE INFORMATION  |
|
|
|
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. MORE INFORMATION  |
|
|
|
Option |