Re: Table scan and LRU caching

Any block is put into the buffer cache. This does not make a difference if it is a full table scan or an index scan. Data is returned to the application from the buffer cache, so it must be read into the buffer cache before the application or user can read the data.

But the big difference lies in the location of the buffer cache list. Blocks read during a full table scan are placed at the Most Recently Used end of the list, as opposed to the Least Recently Used end of the list.

HTH,
Brian

Dirk Mika wrote:
>
> Hi,
>
> as far as i know, blocks read during a full-table-scan are not chached.
> But i had in mind that there is a hint to tell oracle to chache them.
>
> Dirk Mika
> --
> Bayer AG
> WD-AED /LEV
> D-51368 Leverkusen
> Telefon: +49 (214) 30-50360
> Telefax: +49 (214) 30-20031
> Email : dirk.mika.dm1_at_bayer-ag.de
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================