Oracle Disk I/O Tuning: Disk I/O Performance and Optimization for Oracle Databases

Covering all aspects of Oracle disk I/O tuning, this book explores disk performance, RAID management, Oracle data file performance, and Oracle data segment internals. Also explored is physical disk I/O, which includes disk device internals, detecting disk bottlenecks, disk organization techniques, and disk striping and disk load balancing. Highlighted are RAID and Oracle performance as well as techniques for effective use of RAID with Oracle. Additionally, Oracle data file internals are considered and how to use multiple data block sizes to detect and repair Oracle data segment bottlenecks and segment waits is described. Oracle segment management is illustrated, and the effective use of Oracle segment partitioning, segment slot internals, and monitoring segment I/O is explained.

Covering all aspects of Oracle disk I/O tuning, this book explores disk performance, RAID management, Oracle data file performance, and Oracle data segment internals. Also explored is physical disk I/O, which includes disk device internals, detecting disk bottlenecks, disk organization techniques, and disk striping and disk load balancing. Highlighted are RAID and Oracle performance as well as techniques for effective use of RAID with Oracle. Additionally, Oracle data file internals are considered and how to use multiple data block sizes to detect and repair Oracle data segment bottlenecks and segment waits is described. Oracle segment management is illustrated, and the effective use of Oracle segment partitioning, segment slot internals, and monitoring segment I/O is explained.

Mike Ault is one of the leading names in Oracle technology. The author of more than 20 Oracle books and hundreds of articles in national publications, he has five Oracle Masters Certificates and was the first popular Oracle author with his landmark book Oracle7 Administration and Management. Donald K. Burleson is the author of 16 Oracle database books and is the editor in chief of Oracle Internals. He is an Oracle consultant with extensive experience designing and implementing Oracle8 databases, including systems architecture, project management, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP, and tuning very large Oracle databases. He lives in Kittrell, North Carolina.