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:
How did you arrive at the 203.31 MB/s – I calculated 111
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.
I think with newer versions, ‘Database Requests’ in IO Profile section of AWR give you this number.