Re: db_file_multiblock_read parameter in init.ora file
From: Timo Haatainen <Timo.Haatainen_at_ttgroup.fi>
Date: 1996/03/27
Message-ID: <3158E217.31CE_at_ttgroup.fi>#1/1
Date: 1996/03/27
Message-ID: <3158E217.31CE_at_ttgroup.fi>#1/1
Chetan Sheth wrote:
>
> If I set db_file_multiblock_read_count parameter to some high value, let
> say 16. The meaning is Oracle will read 16 blocks in buffer cache in one
> I/O read.
>
> Question: If a query required let say only 2 blocks to read, does Oracle
> still read 16 as db_file_multiblock_read_count set to 16 or it
> will just read 2.
>
> The answer to this question will be highly appreciable.
>
> Chetan
My guess is that Oracle uses db_file_multiblock_read_count parameter when performing full table scans only.
Timo Haatainen Received on Wed Mar 27 1996 - 00:00:00 CET