| Feature Summary | Standard Edition One | Standard Edition | Enterprise or Personal |
High Availability MORE  |
|
|
|
Fail Safe
Configure and verify Windows clusters and automatically fail over Oracle databases and applications 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 including changes to a single row, changes by a rogue transaction, all changes made to one or more tables (including the dropping of a table), and all changes made to an entire database. |
|
|
|
Data Guard
Maintain multiple remote standby copies of production databases automatically; fail over processing from production environment to standby databases; greatly reduce downtime in a disaster situation. |
|
|
|
| Scalability MORE |
|
|
|
Real Application Clusters
Run 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. |
|
|
|
| Security MORE |
|
|
|
Oracle Advanced Security
Address privacy and compliance requirements. Includes Transparent Data Encryption, Network encryption and data integrity, and strong authentication. |
|
|
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
|
|
|
|
Data Encryption
Protect vital data, such as credit card numbers, even in the event of media theft by providing an extra layer of protection for data on storage media. |
|
|
|
| Application Development MORE |
|
|
|
Java Support
Execute Java applications faster, integrate existing software assets, connect Java/J2EE applications to Grid-enabled database, support non-connnected clients through Web Services, and federate local data with remote and dynamic data. |
|
|
|
Application Express
Develop and deploy fast, secure applications with a rapid web application development tool. |
|
|
|
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. |
|
|
|
COM Automation, Microsoft Transaction Server/COM+ integration, ODBC and OLE DB
Support multiple Windows data access methods. |
|
|
|
| Manageability MORE |
|
|
|
Enterprise Manager
Manage 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. |
|
|
|
Automatic Storage Management
Distribute I/O load across all available resources and optimize performance via a vertically integrated file system and volume manager; eliminates manual I/O tuning. |
|
|
|
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. |
|
|
|
Oracle Analytic Functions
Use built-in analytical workspaces for Online Analytical Processing (OLAP). |
|
|
|
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. |
|
|
|
Summary Management - Materialized View Query Rewrite
Improve query performance by automatically recognizing when a materialized view can be used to satisfy a request; transparently rewrite the request to use the materialized view. |
|
|
|
| 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. |
|
|
|
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 |
Ultra Search
Search and locate data across multiple repositories, including: Oracle databases, ODBC compliant databases, IMAP mail servers, HTML documents, files on disk, and more. |
|
|
|
interMedia MORE
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. You can also support the most sophisticated GIS deployments with the Spatial option for Enterprise Edition. |
|
|
|
