Re: Table scan and LRU caching

From: Adrian Shepherd <hashman_at_bigpond.net.au>
Date: Mon, 25 Sep 2000 11:15:28 GMT
Message-ID: <ktGz5.5666$Z06.45560@news-server.bigpond.net.au>

Ahem, netiquette please....

"Frank" <frankbo_at_interaccess.nl> wrote in message news:8qn3ln$709$1_at_porthos.nl.uu.net...
> CACHE
>
> --
> Frank
> Dirk Mika <dirk.mika.dm1_at_bayer-ag.de> schreef in berichtnieuws
> 39CF09D6.5D94F0C4_at_bayer-ag.de...
> > 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
>
>
Received on Mon Sep 25 2000 - 06:15:28 CDT