HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 8

Page 6 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers New Features in Oracle8 Version 8.0 Oracle8 version 8.0 is a major upgrade from Oracle7 version 7.3 and contains many new features. The features covered in this paper are briefly outlined below. For more details on Oracle8 new features, refer to the Appendix A of the Oracle8 Server Migration Manual. New Feature Partitioned Tables and Indexes ROWID Enhancement Data Dictionary Reverse-key indexes SQL*Loader Partitioned Object Support Description Divides large tables and indexes into smaller and more manageable pieces (partitions). Oracle8 includes features to create, manage, backup and recover, and utilize partitions for better query and DML performance. Oracle8 ROWIDs have been modified to handle partitioned tables and tablespace-relative data block addresses (DBAs). The new 10-byte ROWID contains the data object number, data block address and row number of the row. Data Dictionary has more views providing extended information on partitions, parallel server and latches/locks. Also some views have additional columns defined to include new features and functionality. Reverses the bytes of each column indexed, except the ROWID, but keeps the column order. Enables insertions to become distributed across all leaf keys in the index. Supports loading partitioned objects into the database. The direct path has been changed to accommodate mapping rows to partitions of tables and to support local and global indexes. Parallel direct-path includes concurrent loading of an individual partition as well as support for concurrent loading of a partitioned table. © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398