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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 19 Sep 2003 20:09:28 +0800
Message-ID: <3F6AF1F8.5728@yahoo.com>

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

"Depends"

If you want a small number of users, getting maximum IO bandwidth, then the stripes are small to get multiple disks involved in a single multiblock read.

If you want to balance the IO with lots of users, then the each multiblock read should probably be serviced by a single disk, which suggests a stripe size equal to your highest multiblock read

hth
connor Received on Fri Sep 19 2003 - 07:09:28 CDT