Re: Oracle and disk striping

MarkP28665 <markp28665_at_aol.com> wrote:
> From: "MotoX" <rat_at_tat.a-tat.com> >>
> said in answer to question on stripping >>
> If you have small, random reads, then no, striping those tables is not a good
> idea - the overhead of syncing the disks will make things slower. <<

> I disagree since the whole point of stripping is to try to randomize all
> reads/writes to make every I/O an average I/O. Stripping works well with OLTP
> systems since it even outs the disk location of the requests and eliminates hot
> disks. This far and away exceeds the sync cost.

 Agree, it lowers our disks busy time from 99% to 20%.  Short random read-writes in OLTP system. You may also  make striping over mirrored disk for reliability, if you can.  

> These comments are based on personal experience and a book written by a senior
> performance and tuning specialist with Oracle who had Oracle test results to
> back him up.
> The book is at work so I am not sure of the title, but I think it was Unix and
> Oracle Performance Tuning. The publisher is Prentence Hall.

ORACLE PERFOMANCE TUNING , Second Edition Mark Gurry & Peter Corrigan.
O'Reilly & Associates, Inc
ISBN: 1-56592-237-9 --
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru

    aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org           Received on Fri Sep 11 1998 - 05:30:35 CDT