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: db file multiblock read count

Re: db file multiblock read count

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 02 Sep 2005 02:56:56 GMT
Message-Id: <pan.2005.09.02.02.56.55.402983@sbcglobal.net>


On Thu, 01 Sep 2005 06:54:00 -0700, Daniel Fink wrote:

> It will also be limited by segment structure as a multiblock read will
> not cross extent boundaries.

Of course it will not happen. Multiblock read happens if and only if (<=>) there are contiguous blocks that have to be read sequentially. If there is an extent boundary between, blocks are not contiguous, thus MB read can not take place. Q.E.D.

-- 
http://www.mgogala.com
Received on Thu Sep 01 2005 - 21:56:56 CDT

Original text of this message

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