 |
|
Oracle Tips by Burleson |
Oracle Disk I/O Tuning
Chapter 5:
Configuration of CFS or Raw Devices
To take advantage of the
performance optimization, the read or write system call buffer must
be aligned on a page boundary and the I/O must be 512 bytes or a
multiple offset. The size of the I/O must also be 512 bytes or a
multiple thereof. Oracle I/O is sized as a db_block_size
operation or a multiple thereof – both will always be a 512 byte
multiple.
In such a case, the
files in the DB Optimized file system are treated as direct I/O
files, and the I/O is completely un-buffered and not serialized
through any OS locking. Any access to files in a DB Optimized
mounted file system that do not fit the alignment requirements do
succeed – through the buffered I/O path. Regular file system
commands can be used against these files such as cp, rm, compress,
etc.
DB Optimized file
systems are used to store all Oracle data files, redo logs, control
files, SPFILE, OCR file, and CRS voting disk.
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.fast-track.cc or email
info@remote-dba.net.
|
