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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Mar 1999 23:32:30 +0100
Message-ID: <36F8167D.EF440852@sybrandb.demon.nl>


Ideally DB_FILE_MULTIBLOCK_READ_COUNT times db_block_size should equal 64k. 8, 16 and 32 is assuming 8k blocks, 4k blocks, 2k blocks respectively.

Hth,

Sybrand Bakker, Oracle DBA

philippe BACKOUCHE 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)


Received on Tue Mar 23 1999 - 16:32:30 CST

Original text of this message

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