Strange multiblock read events

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Apr 2008 11:31:50 -0700

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.


Other related posts: