Oracle不同版本之区别.doc

Oracle 不同版本之区别 =========================================================== 作者: xsb() 发表于:2006.04.19 10:28 分类: Oracle 出处：/post/419/70362 This document summarizes the differences between Oracle Server releases. Most DBAs and developers work with multiple versions of Oracle at any particular time. This document describes the high level features introduced with each new version of the Oracle database. It is intended to be used as a quick reference as to whether a feature can be implemented, or if a upgrade is required. Oracle 10g Release 2 (10.2.0) - September 2005 Transparent Data Encryption Async commits CONNECT ROLE can only connect Passwords for DB Links are encrypted New asmcmd utility for managing ASM storage Oracle 10g Release 1 (10.1.0) Grid computing - an extension of the clustering feature (Real Application Clusters) Manageability improvements (self-tuning features) Performance and scalability improvements Automated Storage Management (ASM) Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) Flashback operations available on row, transaction, table or database level Ability to UNDROP a table from a recycle bin Ability to rename tablespaces Ability to transport tablespaces across machine types (E.g Windows to Unix) New drop database statement New database scheduler - DBMS_SCHEDULER DBMS_FILE_TRANSFER Package Support for bigfile tablespaces that is up to 8 Exabytes in size Data Pump - faster data movement with expdp and impdp. Oracle 9i Release 2 (9.2.0) Locally Managed SYSTEM tablespaces Oracle Streams - new data sharing/replication feature (can potentially replace Oracle Advance Replication and Standby Databases) XML DB (Oracle is now a standards compliant XML database) Data segment compression (compress keys in tables - only when loading data) Cluster file system for Windows and Linux (raw devices are no longer required). Create logical standby databases with Data Guard Java JDK 1.3 used inside the dat