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

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

Re: Table scan and LRU caching

From: Dirk Mika <dirk.mika.dm1_at_bayer-ag.de>
Date: Mon, 25 Sep 2000 10:16:22 +0200
Message-ID: <39CF09D6.5D94F0C4@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:16:22 CDT












Original text of this message













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