[Oracle-l] Av Rd(ms)

Which statistic are you looking at? There are a number of read statistics.

Thanks Niall,

In the AWR I am looking at this section.
File IO Stats

ordered by Tablespace, File

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av
Writes/s Buffer
Waits Av Buf Wt(ms)

On Tue, May 17, 2011 at 10:55 PM, Niall Litchfield <
niall.litchfield_at_gmail.com> wrote:

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

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

Sincerely,
Pavel.

2011/5/20 Sriram Kumar