RE: Strange multiblock read events

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
To: "Josh.Collier@xxxxxxxxxxxx" <Josh.Collier@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 29 Apr 2008 14:37:25 -0400

Josh,

What's the extent size?  One of the things that can limit multiblock reads is 
an extent boundary.

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Josh Collier
Sent: Tuesday, April 29, 2008 2:32 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Strange multiblock read events

Hi,

Data warehouse environment on solaris 10 with 10.2.0.1. 16k db block size. 
Multiblock_readcount is set to 64.

Most of my multiblock reads show up as 64 blocks, however, every third read or 
so is 59 blocks followed by a 5 block read.

This confuses me.

References:

Strange multiblock read events
From: Josh Collier

RE: Strange multiblock read events

Other related posts: