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

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 19 Sep 2003 20:37:38 +1000
Message-ID: <3f6add0d$2$13416$afc38c87@news.optusnet.com.au>

"Dan Yusuph" <oradba_at_mail.kz> wrote in message news:bkdr8n$jh2v$1_at_ID-175901.news.uni-berlin.de...

> 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

Careful: if you're running anything before 9i, that changes the weighting for the CBO...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Fri Sep 19 2003 - 05:37:38 CDT