How to Calculate the Number of IOPS and Throughput of a Database

How to Calculate the Number of IOPS and Throughput of a Database (Doc ID 2206831.1)

The information regarding IOPS and Throughput can be found in different places of the AWR report:

• Instance Activity Stats
• IO Profile (starting with 11gR2)
• Load Profile 

Instance Activity Stats

IOPS - (Input/Output Operations Per Second) -  This is the sum of Physical Read Total IO Requests and Physical Write Total IO Requests 

Throughput - This is the sum of Physical read total bytes and Physical read total bytes

 For the example above:

IOPS            = Physical Read Total IO Requests + Physical Write Total IO Requests
                    = 83.10 + 361.28
Throughput  = Physical read total bytes + Physical read total bytes
    

How to Calculate the Number of IOPS and Throughput of a Database

The goal of this article is to explain how to calculate the IOPS and throughput of a Database.

The information regarding IOPS and Throughput can be found in different places of the AWR report:

• Instance Activity Stats
• IO Profile (starting with 11gR2)
• Load Profile 

Instance Activity Stats

IOPS - (Input/Output Operations Per Second) -  

This is the sum of Physical Read Total IO Requests 

and Physical Write Total IO Requests 

Throughput - This is the sum of Physical read total bytes and Physical read total bytes

For the example above:

IOPS            = Physical Read Total IO Requests + Physical Write Total IO Requests

                    = 83.10 + 361.28

                    = 444.38

Throughput  = Physical read total bytes + Physical read total bytes

                    = 19,045,685.11 + 42,594,391.17

                    = 61640076.28 bytes

                    = 58.78 MB

IO Profile 

IOPS - Total Requests (This value is the sum of the metrics Physical Read Total IO Requests Per Sec and 

Physical Write Total IO Requests Per Sec from the Instance Activity Stats area)

Throughput in Mbps - Total (MB) (This value is the sum of the metrics Physical read total bytesc/sec 

and Physical read total bytes/sec from the AWR reports.)