|
Oracle Disk I/O Tuning
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.
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
|
