Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Table scan and LRU caching
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