Written by the world's most widely-read DBA and author of over 20 Oracle books, Mike Ault shares his secrets for Oracle DBA management scripts.  This handy reference is indispensable for all Oracle professionals who must quickly tune their disk I/O subsystem. This is the definitive text on Disk I/O Tuning for Oracle Databases. Drawing from the work of the best experts in the world, this book covers all aspects of Oracle disk I/O tuning including disk performance, RAID management, Oracle data file performance and Oracle data segment internals.

This highly-technical treatise explores disk device internals, detecting disk bottlenecks, disk organization techniques and disk striping and disk load balancing. It also covers RAID and Oracle performance and contains in-depth techniques for effective use of RAID with Oracle. The experts also explore Oracle data file internals and show how to use multiple data block sizes and detect and repair Oracle data segment bottlenecks and segment waits. It also explores Oracle segment management and illustrates effective use of Oracle segment partitioning, segment slot internals and monitoring segment I/O.

This text brings together the world’s best Oracle disk experts in this exciting book. This is an indispensable guide for any Oracle professional who must ensure that their Oracle I/O subsystem is properly optimized.
 

Key Features:

• Shows how to create and optimizer physical disk I/O
• Explores disk internals and disk striping
• Explain disk load balancing techniques
• Illustrates the characteristics of RAID levels for Oracle performance
• Contains working scripts to detect disk I/O bottlenecks
• Explain the internals of Oracle data blocks & segments
• Describes multiple file blocksizes and Oracle performance
• Illustrates segment partitioning for maximum Oracle performance
   

About the Author:

 

Mike Ault

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, Mike Ault has five Oracle Masters Certificates and was the first popular Oracle author with his landmark book "Oracle7 Administration and Management".  Mike also wrote several of the "Exam Cram" books, and enjoys a reputation as a leading author and Oracle consultant. Mike started working with computers in 1979 right out of a stint in the Nuclear Navy. He began working with Oracle in 1990 and has since become a World Renowned Oracle expert. Mike is currently a Senior Technical Management Consultant and has two wonderful daughters.  Mike is kept out of trouble by his wife of 29 years, Susan. Mike Ault's Books

Table of Contents:

 

Part I – Disk Devices and Oracle Performance Exploring Disk Size and Oracle Disk I/O Performance – Bruce Rodgers Disk optimization & network performance – enterprise operations management – Drew Robb Using iostat to find disk bottlenecks – Donald K. Burleson Reducing Disk I/O on Oracle Datafiles – Donald K. Burleson Hard disk and how they are organized - enterprise operations management – Drew Robb Diagnosing the Efficiency of Disk Striping and Load Balancing - Mike Hordila Oracle10g automatic storage management Part II – Oracle and RAID RAID and Oracle: Part 1 - David C. Sisk RAID and Oracle: Part 2 - David C. Sisk RAID performance and availability levels – Gilbert Held

Part III - Using SAN and NAS with Oracle   Oracle SAN architecture Database Area Networks - Donald K. Burleson Using NAS with Oracle db_switch approach to instance relocation - Shaul Dar   Part IV – Oracle Data Segment I/O Performance Data block segment internals   Internals of Oracle bottleneck analysis – Robin Schumacher Multiple File Block Sizes in Oracle9i –Donald Burleson Measuring Data Segment Statistics – Arup Nanda Segment Transaction Slot Internals – Arup Nanda   pinpointing I/O hotspots - Schumacher

Material in this text is copyrighted (c) by Auerbach Publishing, all rights reserved.   Used with permission.