Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Table scan and LRU caching
CACHE
-- Frank Dirk Mika <dirk.mika.dm1_at_bayer-ag.de> schreef in berichtnieuws 39CF09D6.5D94F0C4_at_bayer-ag.de...Received on Mon Sep 25 2000 - 03:50:46 CDT
> Hi,
>
> as far as i know, blocks read during a full-table-scan are not chached.
> But i had in mind that there is a hint to tell oracle to chache them.
>
> Dirk Mika
> --
> Bayer AG
> WD-AED /LEV
> D-51368 Leverkusen
> Telefon: +49 (214) 30-50360
> Telefax: +49 (214) 30-20031
> Email : dirk.mika.dm1_at_bayer-ag.de