Re: Strange multiblock read events
- From: Tim Gorman <tim@xxxxxxxxx>
- To: Josh.Collier@xxxxxxxxxxxx
- Date: Tue, 29 Apr 2008 12:56:50 -0600
Any chance that the extents on this table are sized at just under 3Mb?
Quoting Josh Collier <Josh.Collier@xxxxxxxxxxxx>:
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
- References:
- Strange multiblock read events
- From: Josh Collier
Other related posts:
- » Strange multiblock read events
- » RE: Strange multiblock read events
- » Re: 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.
- Strange multiblock read events
- From: Josh Collier