Oracle Disk I/O Tuning

Download or read book Oracle Disk I/O Tuning written by Mike Ault and published by Rampant TechPress. This book was released on 2004-04 with total page 244 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.