On 02/20/2004 09:40:21 AM, Ruth Gramolini wrote:
> Good morning all,
> We just installed a new fast disk farm with fiber channels. For production
> we are using raid 10. My SA set in up with a stipe size of 64K based on the
> size of most of the transactions. He wants to know if this will be OK. I
> don't know so I told him I would ask the experts. What do you think?
>
This will guarantee parallelization of all I/O requests larger then 64k.
Whether it's OK or not, depends on your average I/O size (sar is irreplacible
for this) and whether you have hot disks or not. Also, RAID configurations
usually have caches. Caches, in turn, come in two garden varieties: writhe back
and write thru. Impact of a good write-back cache must not be underestimated,
because it can speed up your commits and checkpoints for an order of magnitude.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 08:52:11 CST
