Oracle10 g各版本差异

Oracle 10g各版本的差异;

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 Fail SafeConfigure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server. MORE Flashback QueryRecover older versions of data without complex, time-consuming operations. MORE Flashback Table, Database and Transaction QueryDiagnose and undo errors to reduce recovery time. MORE Data GuardCreate, maintain, and monitor one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions. MORE Scalability MORE Real Application ClustersRun 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. PL/SQL only Security MORE Oracle Database VaultRestricts super-user and privileged-user access across applications and data. MORE Option Oracle Advanced SecurityAddress privacy and compliance requirements. MORE Option Oracle Label SecurityProvides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. MORE Option Secure Application RolesEnable roles only after a user passes any number of security checks. MORE Virtual Private DatabaseEnforce data security and privacy with customizable, policy-based access control down to the row level. MORE Fine-Grained AuditingAllows highly focused auditing with almost no 'background noise'. MORE Proxy AuthenticationDetects and authenticates users connecting through a middle-tier application. Data Encryption ToolkitProtect vital data by providing an extra layer of protection for data on storage media. MORE Application Development MORE Oracle SQL Developer Graphical tool that enhances productivity and simplifies database development tasks. MORE Application Express Develop and deploy fast, secure applications with a rapid web application development tool. MORE Java Support Grid-enable databases through Web Services. 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. MORE PL/SQL and Java Server Pages Utilize a server-side Java and stored procedural language; secure, portable and seamless with SQL. MORE PL/SQL only Comprehensive Microsoft .Net Support, OLE DB, ODBC Support multiple Windows data access methods. MORE Manageability MORE Enterprise ManagerManage 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. MORE Automatic Storage Management Consistent storage management interface across all server and storage platforms. MORE 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. OLAPUse built-in analytical workspaces for Online Analytical Processing (OLAP). MORE Option PartitioningEnables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications. MORE Option Data MiningEnables efficient information extraction from the very largest databases and integration with business intelligence applications. 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 ManagementUnderstand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept. MORE Summary Management - Materialized View Query Rewrite Automatically recognizing materialized view usage to satisfy requests. 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. MORE 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 XML DB High-performance, native XML storage and retrieval technology. MORE interMedia Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats. MORE Text Build text query applications and document classification applications. MORE Locator Manage geospatial data to leverage the business value of location. MORE Spatial Support for sophisticated GIS deployments. MORE Option

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134878/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134878/