oracle版本区别（Oracle version difference）.docVIP

oracle版本区别（Oracle version difference） What are the new features of Oracle 9i over 8i? Brief: 9i is easier to manage. Elaborate: Concurrent cluster, 8i OPS upgrade to 9i RAC, 8i between nodes using hard disk exchange of information, 9i nodes using high-speed network cache fusion (Cache Fusion) technology to exchange information, exchange speed increased by more than 100 times. 9i can modify kernel parameters and memory allocation online, and 8i doesnt work. Data files and table space management, 8i manual management, 9i automatic management. 9i has increased support for ANSI SQL99 over 8i. 9i enhances the post failure fast recovery (Fast-start) over 8i. 8i only supports physical backup (physical backup) database, the 9i added support for logical backup (logical backup) database, the database backup image as the main database in addition to outside, can also provide other data services. What are the new features of Oracle 10g over 9i? Brief: 10g supports the grid (Grid) and supports automatic management (Automatic, Management). Elaborate: 10g g Grid is the abbreviation for grid computing, namely, multi node server uses high-speed network to form a virtual high performance server, load balancing in the whole grid (Load Balance), according to the needs of additions and deletions of nodes, to avoid single point of failure (Single Point of Faliure). Installation is easy, and installation work is reduced by half over 9i. New browser based Enterprise Manager (Enterprise, Manager). Automatic storage management (ASM), hard disk mirroring, additions and deletions no operating system administrators to set the load balancing, physical volume, logical volume, partition, file system, as long as a Oracle command, ASM will automatically add or remove the hard disk management. Memory automation, automatic allocation and release of system memory as needed. SQL performance tuning automation. Free browser based small application development tools Oracle Application Express (formerly kno