ISBN 0-9745993-4-4 ISBN 13 978-0974599342 Library of Congress Number: 2004101895 300 pages Perfect bind - 9x7 Shelving: Database/Oracle Oracle In-Focus Series # 15

Oracle Disk I/O Tuning Disk IO Performance & Optimization for Oracle Databases Mike Ault Retail Price $27.95 Order now and get immediate online access to the code depot! Only $19.95 (30% off) Key Features About the Author Table of Contents Index Reader Comments Errata

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 is an indispensable guide for any Oracle professional who must ensure that their Oracle I/O subsystem is properly optimized.

* 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:

Table of Contents:

Chapter 1 - Disk Architecture Introduction General Disk Architecture Disk Layout Disk Logic Boards Cache and Disks Disk Performance Statistics Disk Capacity - The Double-Edged Sword Conclusion References Chapter 2 - Disk Interfaces Exploring Disk Interfaces ATA Interface SCSI Interface SCSI 3 IEEE1394 Interface IEEE1394 protocol Layers Fibre Channel Channels and Fibre Channel Networks and Fibre Channel Fibre Topologies Nodes Ports Fibre Channel Links Arbitrated Loop Topology Conclusion References Chapter 3 - Optimizing Disk Performance Optimizing Your Disk Interface Optimizing ATA Performance ATA Tuning In Windows ATA Tuning in LINUX. Notes Tuning the SCSI Interface Tuning the SCSI Interface in Windows SCSI Tuning Under Linux Tuning SCSI Under UNIX Peripheral Buses SCSI Bus SUN Conclusions for SCSI Interface Tuning HP-UX SCSI Tuning SCSI Tuning Under AIX Setting AIX SCSI-Adapter and Disk-Device Queue Limits AIX SCSI Settings With a Non-IBM Disk Drive Setting SCSI Parameters for a Non-IBM Disk Array Changing AIX Disk Adapter Outstanding-Request Limits Controlling the Number of System pbufs in AIX Tuning the IEEE1394 Interface Tuning the Fibre Channel Interface Conclusion References Chapter 4 - RAID Technology Disk Striping Disk Shadowing or Mirroring RAID—Redundant Arrays of Inexpensive Disks RAID Setup for SCSI EMC Storage Arrays Hitachi Storage Arrays Compaq (HP) Storage Array IBM Storage Arrays SUN StorEdge Storage Arrays Commonalities between the Arrays Memory Caches IO Profiles Tune for Concurrency The IO Path The 100% Myth Should I Worry About Fragmentation? What About Write Caching? Conclusion References

Chapter 5 - Disk Monitoring Introduction Oracle Monitoring Operating System Monitoring of Disks Automating Statistic Collection Conclusion Chapter 6 - Solid State Disk and Oracle Databases Introduction Oracle Data Caching SSD as an Oracle Tuning Tool RAM Access Speed with Oracle Databases The History of Oracle RAM Data Buffering Allocating Oracle Objects into Multiple RAM Data Buffers Improving I/O Speed Is Not a Silver Bullet The Problem of Duplicitous RAM Caches Why is Oracle Logical I/O So Slow? Finding the Baselines A Review of Existing SSD Research Findings James Morle Paul Dorsey Woody Hutsell Conclusion References Chapter 7 - Oracle 10g Disk Related Features Automatic Storage Management ASM Concepts ASM Architecture ASM Instance Management Initialization Parameters for ASM Instance Disk Recovery Time Rebalance Operation ASM Instance Operations Starting Up and Shutting Down of an ASM Instance Discovering the Disks and Disk Groups ASM Instance Configuration Rules and Guidelines for ASM Instance Configuration Creating a Disk Group Altering a Disk Group (add, drop, undrop, resize, rebalance) Mounting Disk Groups Disk Group Templates Alias Filenames Dropping a Disk Group Internal Consistency of Disk Groups File Types Supported by ASM Dynamic Performance Views on ASM How Do We Use ASM Files in the Database? Using ASM to Create a Database Conclusion

Index Topics:

Reviews:

Errata: