|  |
|
Oracle Tips by Burleson |
Disk I/O Tuning
Chapter 3: SUN
Conclusions for SCSI Interface Tuning
In
order to have a properly tuned interface, you must make sure the
proper SCSI options are set at the system (/etc/system) and bus as
well as device level (scsi_options). Make sure that the proper
command queued depth (sd_max_throttle) and proper command delay
times (sd_io_time) are set. In a mixed environment (multiple SCSI
devices with different queue depths and IO considerations) set these
at the device level or the entire SCSI system or bus will be drug
down to the performance of the least powerful device. Finally, try
to isolate tape or other low speed devices on their own SCSI bus as
their device numbers are usually set to 6, which causes them to
usurp service from other devices in the chain.
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
|
