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 ?
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