Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?
We found multiples of (ChunkSize/db_block_size)*StripeWidth performing very
well in a RAID 1+0 environment. I've seen a whitepaper on this somewhere.
tienlee_at_mailexcite.com schreef in artikel
<7ded0q$9bb$1_at_nnrp1.dejanews.com>...
> Multiple of 5 ? I honestly don't think so or maybe I have been missing
> this out over the years.
>
> Usually, I used the formula:
>
> DB_FILE_MULTIBLOCK_READ_COUNT = OS I/O Block / db_block size
>
> Remeber, higher doesn't mean faster but should tune according
> to your OS limitations.
Received on Mon Mar 29 1999 - 04:03:30 CST