Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Table scan and LRU caching

Table scan and LRU caching

From: <sergey_s_at_my-deja.com>
Date: Fri, 22 Sep 2000 19:41:02 GMT
Message-ID: <8qgcka$lld$1@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. Received on Fri Sep 22 2000 - 14:41:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US