Re: Table scan and LRU caching

Most of the low-level answers to this question so far describe the mechanisms used in
previous releases of Oracle. Oracle 8.1 has a much more sophisticated set of mechanisms for handling the block buffer (and its multiple pools and LRU chains).

The best site to watch for the most accurate and up-to-date information is Steve Adams' on www.ixora.com.au

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

sergey_s_at_my-deja.com wrote in message <8qgcka$lld$1_at_nnrp1.deja.com>...


>How long do the blocks read during a full table scan stay in the cache?

>When a full table scan is performed, how many blocks are pushed into the

>cache at the least recently used end? I am particularly interested in

>how Oracle manages the cache when blocks from table scans are read

>along with the blocks from index reads (which come in through the most

>recently used end).

>

>Thank you.

>Sergey

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.