Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: multiblock read count question
"Rob K" <robkato_at_earthlink.net> wrote in message news:<Qc2Y6.21823$aV1.2190988_at_newsread1.prod.itd.earthlink.net>...
> Why would I be getting the same response time on full scans if the
> multiblock read count is set to 2 or 32?
>
> System:
> Oracle 8.1.7 block size 8k
>
> Sun 4500
> 2-5200 drives
> Veritas
> stripe = 4 drives with 256k interleave size = 1M stripe size.
> max i/o = 1M
Hi Rob!
To get performance gain from stripping read request should be distribute
on all 4 drives. So you should set multiblock read count to 128 !
Regards,
Slava.
Received on Thu Jun 21 2001 - 02:05:40 CDT
![]() |
![]() |