RE: Strange multiblock read events

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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier Sent: Tuesday, April 29, 2008 2:32 PM
To: oracle-l_at_freelists.org
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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 29 2008 - 13:37:25 CDT