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 |