The hint is the (table level) CACHE hint:
The CACHE hint specifies that the blocks retrieved for this table
are placed at the most recently used end of the LRU list in the buffer
cache when a full table scan is performed.
(Better, Adrian?)
--
Frank
Adrian Shepherd <hashman_at_bigpond.net.au> schreef in berichtnieuws
ktGz5.5666$Z06.45560_at_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 - 08:09:58 CDT
