RE: iostat and awr File IO Stats difference

Document TitleAWR Report Shows Huge Numbers For Av/Rd (Doc ID 465106.1)

https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=465106.1&h=Y

There's also this
Document TitleAWR REPORTS INCORRECT IO STATS FOR TABLESPACES AND DATAFILES (Doc ID 827104.1) https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=827104.1&h=Y

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of joshuasingham Sent: Wednesday, August 03, 2011 10:00 AM To: oracle-l_at_freelists.org
Subject: iostat and awr File IO Stats difference

Hi ,

I been looking at some (10.2.0.4) on AIX 64 bit Awr report File IO Stats and can see that the Av Rd(ms) for some of the files are consistently above 50 to 60 ms over a 15min interval but when I reported this storage guy he mention and sent me the Iostat to prove that the service time in the same timeline is average of 20ms for the disk involve . What can cause the difference between the AWR and iostat readings

thanks

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