Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table scan and LRU caching

Re: Table scan and LRU caching

From: Frank <frankbo_at_interaccess.nl>
Date: Mon, 25 Sep 2000 10:50:46 +0200
Message-ID: <8qn3ln$709$1@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 - 03:50:46 CDT












Original text of this message













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