|  |
|
Oracle Tips by Burleson |
Disk I/O Tuning
Chapter 3:
Conclusions
Tuning disk interfaces generally involves controlling the number of
commands that are sent to each disk on the interface. These
commands are controlled via the mechanism of queued command depths
where the number of commands sent to either a bus or device is
preset to prevent command overflows. Another setting throttles the
total flow of commands on the bus to individual devices and provides
for load balancing (sd_max_throttle for example). When the disk
interface senses errors, it usually throttles back to the minimal
settings (usually 1), which can severely inhibit performance.
IEEE1394 Firewire/ilink, XILINX, ESP - Emerging
Standards and Protocols, PowerPoint Presentation, www.xilinx.com
www.westerndigital.com FAQ section
www.seagate.com
www.princeton.edu/~unix/Solaris/troubleshoot/diskio.html
SunSolve Document ID: 1227
QLogic Corporation QLA2100F PCI Fibre Channel Adapter
RELEASE NOTES FOR SYMMETRIX ICDA SYSTEM UPDATED: July
27, 1999
HP-UX Reference, HP-UX 11i Version 1.6, Customer
Order Number: ONLINE ONLY, HP Part Number:B3921-90010, June 2002,
Printed in USA, Copyright 1983-2002 Hewlett-Packard Company. All
rights reserved.
AIX Versions 3.2 and 4 Performance Tuning Guide,
Fifth Edition (April 1996), IBM Corp.
AIX 5L Version 5.1, Performance Management Guide,
Third Edition (April 2002), Copyright International Business
Machines Corporation 1997, 2002
The above text is
an excerpt from:
Oracle Disk I/O Tuning
Disk IO Performance & Optimization for Oracle
Databases
ISBN
0-9745993-4-4
by Mike Ault
Oracle Consulting
Services
Burleson
Oracle Consulting offers Senior Oracle consultants which are available for all
areas of Oracle support. Common Oracle consulting support activities include
short-term Oracle tuning, Oracle database troubleshooting, Oracle9i and
Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
-
Answering
questions from your Oracle DBA technical staff
-
Repairing down
production Oracle database systems
-
One-time
Oracle tuning evaluation
-
Guru support
for your Oracle DBA
-
Installation
of Oracle application packages
For more
information, please visit
www.rampant-books.com
|
