Strange multiblock read events
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 29 Apr 2008 11:31:50 -0700
Message-ID: <578806DDE66A3A45916740EB73C6982A01016870438F@M1EXCHANGE01.mmi.local>
Date: Tue, 29 Apr 2008 11:31:50 -0700
Message-ID: <578806DDE66A3A45916740EB73C6982A01016870438F@M1EXCHANGE01.mmi.local>
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-lReceived on Tue Apr 29 2008 - 13:31:50 CDT