|
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) |
 |
Get the
Oracle Tuning Library
Save $100 - All four books for only $118.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.
|
|
* 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
|
|
