About the White Paper:
This series of book excerpts is from the soon-to-be-released Rampant TechPress book "Oracle disk I/O tuning," written by Mike Ault. Each excerpt in this series focuses on a different aspect of disk I/O performance and optimization for Oracle databases. Check back frequently for new excerpts.
Current list of excerpts:
1. General disk architecture
2. Disk layout
3. Disk performance statistics
4. Disk capacity -- The two-edged sword
5. Optimizing ATA performance
6. ATA tuning in Linux, part 1
7. ATA tuning in Linux, part 2
8. ATA tuning in Linux, part 3
9. ATA tuning in Linux, part 4
10. ATA tuning in Windows
11. Tuning the SCSI interface in Windows
12. SCSI tuning under Linux and Unix
13. The SCSI bus, part 1
14. The SCSI bus, part 2
15. HP-UX SCSI tuning, part 1
16. HP-UX SCSI tuning, part 2
17. SCSI tuning under AIX
About the book
Written by the world's top 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 subsystems. 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 is an indispensable guide is for any Oracle professional who must ensure that their Oracle I/O subsystem is properly optimized.
Click here to order the book. | 
