Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RAID strip size and db_file_multiblock_read_count

RAID strip size and db_file_multiblock_read_count

From: <chuckh_at_safeplace.net>
Date: Mon, 29 Mar 1999 16:45:58 GMT
Message-ID: <7doao3$eb7$1@nnrp1.dejanews.com>


The ORACLE tuning guide says that the minimum strip size to use in a raid array is twice that of db_block_size * db_file_multiblock_read count? Why is this? Won't that force each read for a table scan to be limited to one disk in the array? I'd think that you'd get better performance by making it just the opposite and so that each table scan read is done accross multiple disks. -- Chuck Hamilton chuckh_at_safeplace.net

If at first you don't succeed, skydiving isn't for you!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 29 1999 - 10:45:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US