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
Built-in clustering
services to protect any Oracle application or any other kind of
application within a cluster. |
|
|
|
|
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
|