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 -> Re: LRU algorithm - question

Re: LRU algorithm - question

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: Sun, 24 Sep 2000 10:04:11 +0200
Message-ID: <8qkc2l$e18$1@garnet.hamburg.cityline.net>

Blocks from a full table scan are not cached.

Regards

   Roger

<sergey_s_at_my-deja.com> schrieb im Newsbeitrag news:8qjp3s$b30$1_at_nnrp1.deja.com...
> Data blocks placed in cache at the most recently used end "age out" by
> moving to the least recently used end where they get removed from
> memory.
>
> What happens to the blocks from full table scans? I know they are placed
> at the least recently used end, but do they remain in cache for some
> time? Is there also some sort of "aging out" process?
>
> Thnk you!
> Sergey
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Sep 24 2000 - 03:04:11 CDT

Original text of this message

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