Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db file multiblock read count
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.comReceived on Thu Sep 01 2005 - 21:56:56 CDT