Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?

From: <tienlee_at_mailexcite.com>
Date: Thu, 25 Mar 1999 22:23:32 GMT
Message-ID: <7ded0q$9bb$1@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.

Hope this helps.

In article <7d80v1$dbe$1_at_news.imaginet.fr>, "philippe BACKOUCHE" <philippe_at_arpege.imaginet.fr> wrote:
> Hi everybody,
>
> I read thah Oracle roundes each extent to a multiple of 5 blocks, so my
> question is :
>
> should DB_FILE_MULTIBLOCK_READ_COUNT be multiple of 5 ? and if so , why
> aren't the default values in the initXXX.ORA 8, 16, or 32 ?
>
> Best Regards,
>
> Philippe (philippe_at_arpege.imaginet.fr)
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 25 1999 - 16:23:32 CST