Re: Av Rd(ms)

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Fri, 20 May 2011 14:24:58 +0300
Message-ID: <BANLkTi=Ra7LbTqWpNSquqaunvD5_NyX7Ow_at_mail.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 Fri May 20 2011 - 06:24:58 CDT

This message: [ Message body ]
Next message: Sriram Kumar: "What utilities/tools do you use to Organize Oracle Articles/Tips?"
Previous message: Maclean Liu: "Question about Library cache latch in 11g"
In reply to: K R: "Av Rd(ms)"
Next in thread: Pavel: "Re: Av Rd(ms)"
Reply: Pavel: "Re: Av Rd(ms)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message