| |
 |
|
Oracle Tips by Burleson |
Oracle Disk I/O Tuning
Chapter 5:
For files,
such as log files, that require low latency, ASM provides
fine-grained (128k) striping to allow larger I/Os to be split and
processed in parallel by multiple disks. At file creation time, you
can decide whether or not to use fine-grained striping. File type
specific templates in the disk group determine the default behavior.
Most
installations will probably have two or more disk groups. The
reasons for having multiple different disk groups include the
following:
-
To group disks of different
manufacturers, different sizes or performance characteristics.
-
To group disks with different
external redundancy together; for example, JBOD (just a bunch of
disks) would generally not be in the same disk group with disks from
a RAID 1+0 or RAID5 configuration, but this is possible using ASM.
-
To separate work and recovery
areas for a given database.
Note: In any installation, non-ASM
managed operating system storage repositories are required, and
are used for swap files, execution libraries, and user file
systems. The Oracle database and ASM executable files and
libraries must reside on the server’s operating system file
system and cannot reside in an ASM files.
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.oracle-training.cc.
|
