Home > Oracle Performance Tools > How to identify IOPS in AWR reports

How to identify IOPS in AWR reports

The AWR reports are very usefull during the performance troubleshooting and also during proactive analysis.

One of the first steps in order to have apicture of the current environment is to know how are Oracle Database performance compared to the current hardware infrastructure.    The IOPS (Input/Output Operations Per Second) is one of the very interesting information to know before going deeper in the investigation.

The IOPS can tell you how many physical I/Os were executed in the last interval. If you see good performance then you can move forward in other directions.

Unfortunatelly you have to know what kind of hardware are available to the Database Server. Each different HW has different performances.

See below how to identifiy IOPS and MB/s from the AWR reports:

  1. tim carroll
    June 14, 2013 at 12:26 pm

    How did you arrive at the 203.31 MB/s – I calculated 111

    • June 15, 2013 at 9:53 am

      Hello Tim,
      thanks for this comment. In fact the value 111,841,061.40 is in byte then I divided by 1024 to get in KBytes then by 1024 to get in MBytes.
      In any way the value is incorrect. The correct value is 106MB/s. Sorry about that.

  2. September 16, 2015 at 5:46 am

    I think with newer versions, ‘Database Requests’ in IO Profile section of AWR give you this number.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: