Re: Strange multiblock read events

Any chance that the extents on this table are sized at just under 3Mb?

Quoting Josh Collier <Josh.Collier_at_banfield.net>:

> 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