DB IOPS & Throughput from AWR report Oracle DB

Detailed I/O Metrics and Network Throughput

The AWR report provides more granular I/O and network metrics, often summarized in an "I/O Profile" or found within "Instance Activity Stats."

I/O Profile (Summary):

• IOPS: Total Requests: Read + Write Per Second

• Throughput (MB): Total (MB): Read + Write Per Second

Mapping from "Instance Activity Stats" to "IO Profile":

Instance Activity Stats Metric	IO Profile Metric (Per Second)
physical read total IO requests	Total Requests: Read per Second
physical write total IO requests	Total Requests: Write Per Second
physical read total bytes / 1024 / 1024	Total (MB): Read per Second
physical write total bytes / 1024 / 1024	Total (MB): Write Per Second

Mapping from "Load Profile" to "Instance Activity Stats":

Load Profile Metric	Instance Activity Stats Metric
Read IO requests	physical read IO requests
Write IO requests	physical write IO requests
Read IO(MB)	physical read bytes
Write IO(MB)	physical write bytes

Network Throughput:

These metrics provide insight into network activity related to SQL*Net communication.

• bytes received via SQL*Net from client

• bytes sent via SQL*Net to client

• MB received via SQL*Net from client

• MB sent via SQL*Net to client