--_=_NextPart_001_01C3B825.DE0C531A
Content-Type: text/plain
you may want to raise a call with Oracle support about this. We have an call
open with them at present and they have raised a bug for us. We were
noticing the same thing as you experienced on AIX 5L 9i RAC 9.2.0.3.
Apparently Oracle
Ian,
Index Range Scans are single block i/o (fast full scans use multiblock
i/o). This is why you are seeing the high number of single block reads.
If you want to use multiblock reads, use full table scans or fast full
index scans. Be warned, response time could drop dramatically (along with
your