Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

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

 

Oracle Disk I/O Tuning
Disk I/O 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
     
Get the Oracle Tuning Library
Save $100 - All four books for only $118.95 
Oracle Tuning: The Definitive Reference 3rd Edition $69.95
Advanced Oracle SQL Tuning: The Definitive Reference $59.95
Oracle Performance Troubleshooting 2nd Ed $34.95
Oracle Tuning Powerscripts $37.95

 


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.

 
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 has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 

 

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

A
Advanced Technology Attachment
Arbitration phase
asm_diskgroups
asm_diskstring
asm_power_limit
Automatic Memory Management
Automatic Storage Management
Automatic Workload Repository
Average Latency
Average Read Seek
B
Bus Free phase
C
clustering_factor
Command phase
control_files
D
Data phase
Data In phase
Data Out phase
Data Transfer Rate
Database Configuration Assistance
Database Configuration Assistant
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_cache_size
db_create_file_dest
db_create_online_log_dest_n
db_keep_cache_size
db_recovery_file_dest.
db_recycle_cache_size
db_unique_name
dba_hist
dba_hist_db_cache_advice
dba_hist_filestatxs
dbms_stats
dbshut
dbstart
default_disk_ir
DeviceParameters
DisableDisconnects
DisableSynchronousTransfers
DisableTaggedQueuing
E
Enclosure Services Commands
F
Fast synchronous transfer option
Fibre Channel
Fibre Channel Arbitrated Loops
Firewire
Full Stroke Read Seek
H
hdparm
I
IDE Block Mode
IEEE
IEEE-
immediate_report
init.ora
instance_type
Integrated Drive Electronics
iostat
K
keep_features_over_reset
keep_settings_over_reset
L
Link Layer
log_archive_dest
log_archive_dest_n
log_archive_format
M
Management Server Commands
MaximumLogicalUnit
MaximumSGList
Media Changer Commands
Message phase
Message In phase
Message Out phase
Multimedia Commands
N
Node Loop Ports
O
Object-based Storage Device
optimizer_index_caching
optimizer_index_cost_adj
optimizer_mode
Oracle Enterprise Manager
oratab
osm_diskgroups
OSMB
P
Physical Layer
R
RBAL
REG_DWORD
Reselection phase
S
sar
SCSI Block Commands
SCSI Controller Commands
SCSI Graphics Commands
SCSI Stream Commands
scsi_max_qdepth
scsi_maxphys
scsi_options
scsictl
sd_io_time
sd_max_throttle
Selection phase
sio_set_lun_limit
Small Computer System Interface
spfile
standby_archive_dest
Status phase
T
Track-to-Track Seek
Transaction Layer
U
using_dma
V
v$aasm_operation
v$asm_alias
v$asm_client
v$asm_disk
v$asm_diskgroup
v$asm_file
v$asm_operation
v$asm_template
v$db_cache_advice
v$filestat
v$tempstat
vmstat
vmtune

 

Reviews:

 

Errata:


Note: Oracle changed the names of the following views from v$osm to v$asm, and they may be different, depending on your release level of Oracle10g:

http://otn.oracle.com/pls/db10g/db10g.drilldown?word=v$osm_alias


 

 

 

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks