Re: AWR report- what does this metric mean ?

It's the average buffer busy wait time - except it includes the "read by other session" waits as "buffer busy wait".

Check your file I/O histogram for anomalies

Regards
Jonathan Lewis

JC1706_at_att.com wrote:
> I have a SR opened with Oracle, but I am struggling to determine what thi=
> s metric in AWR means-
>
> Av Buf Wt(ms) - I cannot tell if this means Average Buffer Wait(ms), or =
> Average Buffer Write(ms). In the
> Context of the earlier "Av Rd(ms)" it makes me think that its Average Bu=
> ffer Write, but how can I get such a
> Wide range between reads and writes? This is on a very high end NetApp s=
> an storage. The AWR report for disk i/o does not match the SAN statistic=
> s at all- we get sub-5 ms i/o's reported on the SAN side, but on the OS s=
> ide I do see some above average times under i/o stat, but still sub-15ms =
> times when it gets ugly.
>
> Tablespace IO Stats DB/Inst: xxxx/xxxxxx Snaps: 26941-2698=
> 7
> -> ordered by IOs (Reads + Writes) desc
>

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