|
|
| Re: striping [message #37675 is a reply to message #37666] |
Wed, 20 February 2002 01:09  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
Purpose of Striping
-------------------
Striping divides a large table’s data into small portions and stores these portions in
separate datafiles on separate disks. This permits multiple processes to access
different portions of the table concurrently without disk contention. Striping is
particularly helpful in optimizing random access to tables with many rows. Striping
can either be done manually (described below), or through operating system
striping utilities.
I/O Balancing and Striping
------------------------------------
Benchmark tuners in the past tried hard to ensure that the I/O load was evenly
balanced across the available devices. Currently, operating systems are providing
the ability to stripe a heavily used container file across many physical devices.
However, such techniques are productive only where the load redistribution
eliminates or reduces some form of queue.
If the wait service time exists, along with high percentage busy on a drive, then I/O
distribution may be required. Where larger numbers of physical drives are
available, consider dedicating two drives to carrying redo logs (two because redo
logs should always be mirrored either by the operating system or using Oracle redo
log group features). Because redo logs are written serially, drives dedicated to redo
log activity normally require limited head movement. This significantly accelerates
log writing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
