64k or 128k stripe - 8k block 8 multiblock read?

From: Dan Yusuph <oradba_at_mail.kz>
Date: Fri, 19 Sep 2003 09:57:03 +0600
Message-ID: <bkdr8n$jh2v$1@ID-175901.news.uni-berlin.de>

Domenic G. <domenicg_at_hotmail.com>
wrote in message news:c7e08a19.0309181631.14ab09a4_at_posting.google.com...

D> Assuming a db_block_size of 8k with a db_file_multiblock_read_count of 8
D> 8k x 8 = 64k
D> Should I set my disk stripe size to 64k or 128k for the most efficient
D> I/O for FTS?  The Oracle docs give contradictory advice.

for "most efficient I/O for FTS" you should try next settings: configure your raid set stripe size 1M
db_block_size = 8192
db_file_multiblock_read_count = 128

Dan Received on Thu Sep 18 2003 - 22:57:03 CDT