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: Does it read empty blocks into buffer cache ?

Re: Does it read empty blocks into buffer cache ?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 22 Jan 2003 21:07:01 -0000
Message-ID: <3e2f0851_3@mk-nntp-1.news.uk.worldonline.com> 





"tingl" <one4all_at_all4one.not> wrote in message
news:NAlX9.4937$Sv3.524551_at_newsread1.prod.itd.earthlink.net...


> No, Oracle does not scan empty blocks. It would be inefficient to do so.

>




How would it know whether or not the block is empty until it has read it?



Regards,


Paul
Received on Wed Jan 22 2003 - 15:07:01 CST












Original text of this message













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