Home » SQL & PL/SQL » SQL & PL/SQL » striping
striping [message #37666] Tue, 19 February 2002 20:41 Go to next message
Messages: 141
Registered: October 1998
Senior Member
What is striping?
Re: striping [message #37675 is a reply to message #37666] Wed, 20 February 2002 01:09 Go to previous message
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.
Previous Topic: Logging events
Next Topic: performance
Goto Forum:

Current Time: Sun Sep 19 05:43:03 CDT 2021