Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: multiblock read count question

Re: multiblock read count question

From: Viacheslav Leichinsky <v_leichinsky_at_ittoolbox.com>
Date: 21 Jun 2001 00:05:40 -0700
Message-ID: <beb04beb.0106202305.5f81460c@posting.google.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US