Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: LRU algorithm - question
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
![]() |
![]() |