Re: Av Rd(ms)

From: Pavel <ocp.pauler_at_gmail.com>
Date: Mon, 23 May 2011 13:58:40 +0400
Message-ID: <BANLkTi=HYzuKpf4=0gZ=v_i-LKTZtq_KmQ_at_mail.gmail.com>

Hi
 I think 3-8 ms is a good time for read :) (in most environment)

Sincerely,
 Pavel.

2011/5/20 Sriram Kumar <k.sriramkumar_at_gmail.com>

> Hi Kart,
>
> In my opinon there is no magical number that suits any environment. It
> depends on the application workload and how much IO contributes to the
> workload (Contributing to top events in AWR). Higher the IO contribution,
> lower would be the requirement for the response time if you intend to tune
> it.
>
> I Do have to state that this number would be averaged over REAL physical
> reads coming from the disks and logical reads coming from layers outside
> oracle ( JFS cache, SAN Cache) etc
>
> Best Regards
>
> Sriram
>
>
>
> On Wed, May 18, 2011 at 3:15 AM, K R <kp0773_at_gmail.com> wrote:
>
>> All,
>>
>> What is the range I should be looking at for file i/o average read in
>> milli second in a ASM environment.
>>
>> I see some of my database have average read between 3ms and 8ms .
>>
>> appreciate any suggestion
>>
>> thanks
>> Kart
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 23 2011 - 04:58:40 CDT