Re: multiblock_io count on NT

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/08
Message-ID: <66gl4s$1ca$1@news01.btx.dtag.de>#1/1

alex smith wrote:
>
> Hi everybody,
>
> I am a newbie to Oracle 7.3.3 on NT. Could someone please give me some
> guidelines for setting the initialization parameter for multiblock I/O
> on an Intel box running Oracle 7.3.3 on NT 4.0. Could someone please
> give some advise as I have to install a Oracle ion NT very soon.
Hi,

try to set db_file_multiblock_read_count=64k/db_block_size. If db_block_size=8k you'll only get 7 blocks read at a time 'cause Oracle has an overhead of about 250-512 byte.

-- 
Regards

Matthias Gresz    :-)

Received on Mon Dec 08 1997 - 00:00:00 CST