RE: iostat and awr File IO Stats difference

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "'joshuasingham@xxxxxxxxx'" <joshuasingham@xxxxxxxxx>
  • Date: Wed, 3 Aug 2011 10:24:01 -0500

Well, there's this for IBM zOS systems

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@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of joshuasingham
Sent: Wednesday, August 03, 2011 10:00 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: