Re: Does it read empty blocks into buffer cache ?

From: grjohnson <Johnsog123_at_hotmail.com>
Date: 21 Jan 2003 16:24:47 -0800
Message-ID: <32b8a689.0301211624.702c3e07@posting.google.com>

DA Morgan <damorgan_at_exesolutions.com> wrote in message
>
> Oracle will read to the high-water mark if doing a full-table scan. If
> it didn't how would it know there was nothing there?
>
> Daniel Morgan

Adding to Daniel answers, if the TABLE in question was created with the NOCACHE option, then during the FTS (yes, upto the HWM), the blocks are read into the LRU end on the Buffer Cache at a rate of DB_FILE_MULTIBLOCK_READ_COUNT + 1. Cheers,

Greg Johnson Received on Tue Jan 21 2003 - 18:24:47 CST