The information regarding IOPS and Throughput can be found in different places of the AWR report:
Instance Activity StatsIO Profile (starting with 11gR2)Load Profile
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
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.)
The information in the "IO Profile" is just a summary of the information in "Instance Activity Stats".
Instance Activity StatsIO Profile physical read total IO requestsTotal Requests: Read per Secondphysical write total IO requestsTotal Requests: Write Per Secondphysical read total bytes / 1024 / 1024 Total (MB): Read per Secondphysical write total bytes / 1024 /1024Total (MB): Write Per SecondIOPSTotal Requests: Read+Write Per SecondThroughput (MB)Total (MB): Read+Write Per Second
Please note that the information displayed here is a subset of the one in the IO Profile area:
Load profileInstance Activity StatsRead IO requestsphysical read IO requestsWrite IO requestsphysical write IO requestsRead IO(MB)physical read bytesWrite IO(MB)physical write bytes
physical read IO requests Number of read requests for application activity (mainly buffer cache and direct load operation) which read one or more database blocks per request. This is a subset of "physical read total IO requests" statistic.
physical read total IO requests Number of read requests which read one or more database blocks for all instance activity including application, backup and recovery, and other utilities. The difference between this value and "physical read total multi block requests" gives the total number of single block read requests.
