| 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 | |||
Oracle Database 11g Editions
登录后才可评论.
