||Oracle Tips by Burleson
Disk I/O Tuning
ATA Tuning in LINUX
no flags are given, acdgkmnru is assumed.
- Get/set sector count for file system read-ahead. This is used
to improve performance in sequential reads of large files by
pre-fetching additional blocks in anticipation of them being
needed by the running task. In the current kernel version
(2.0.10), this has a default setting of 8 sectors (4KB). This
value seems good for most purposes, but in a system where most
file accesses are random seeks, a smaller setting might provide
better performance. Also, many IDE drives have a separate
built-in read-ahead function, which alleviates the need for a
file system read-ahead in many situations.
- Disable/enable the IDE drive's read-look ahead feature
(usually ON by default).
- Set Advanced Power Management feature, if the drive supports
it. A low value means aggressive power management and a high
value means better performance. A value of 255 will disable apm
(automatic power management) on the drive. When a drive spins
down due to reaching its apm timeout, it may take up to 30
seconds to respond to the first request after the timeout.
- Query/enable (E) IDE 32-bit I/O support. A numeric parameter
can be used to enable/disable 32-bit I/O support:
The above text is
an excerpt from:
Oracle Disk I/O Tuning
Disk IO Performance & Optimization for Oracle
by Mike Ault
can offer world-class remote Oracle database support at super-affordable prices.
Oracle DBA service provides 100% of the remote Oracle database administration
needs for your company, and includes 24x7 access to our staff of 100% OCP
Certified Oracle DBAs.
We require a 12 month service commitment and include the following services:
- Initial configuration review and problem identification
- Installation of Oracle statistics collection mechanisms and quarterly
database growth summaries
- Hourly monitoring of your Oracle database for pending problems
- Periodic performance analysis & identification of tuning activities
- Twenty Four hour Oracle emergency support
- Reporting and resolving all serious Oracle alert log messages
- Free use of the BC
- Quick response emergency support for production database outages
- Four hours of free remote DBA support every month. You can use these free
hours for any DBA activity, including database analysis, system design,
production migrations or personal mentoring.
information, please visit
www.oracle-training.cc or email firstname.lastname@example.org.