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 -> Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?

Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?

From: Kaboel Karso <karso_at_kpn.com>
Date: 29 Mar 1999 10:03:30 GMT
Message-ID: <01be79cb$34d04920$ce1e1dac@ut9811252159>


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

Original text of this message

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