Archive for November, 2012

How to identify IOPS in AWR reports

November 8, 2012 3 comments

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: