db_file_multiblock_read parameter in init.ora file
From: Chetan Sheth <chetan_at_iscp.bellcore.com>
Date: 1996/03/22
Message-ID: <3152FA2A.41C6_at_iscp.bellcore.com>#1/1
Date: 1996/03/22
Message-ID: <3152FA2A.41C6_at_iscp.bellcore.com>#1/1
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 Received on Fri Mar 22 1996 - 00:00:00 CET