How to Calculate the Number of IOPS and Throughput of a Database (文档 ID 2206831.1)-优快云博客

本文详细解释了在Oracle AWR报告中如何获取IOPS（每秒输入/输出操作次数）和吞吐量的数据，并展示了这些指标的计算方法。通过实例活动统计和I/O配置文件等部分的具体数据说明，帮助读者理解数据库性能监控的关键参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.)

ioprofile

The information in the "IO Profile" is just a summary of the information in "Instance Activity Stats".

Instance Activity Stats	IO Profile
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
IOPS	Total Requests: Read+Write Per Second
Throughput (MB)	Total (MB): Read+Write Per Second

Load profile

Loadprofile3

Please note that the information displayed here is a subset of the one in the IO Profile area:

Load profile	Instance Activity Stats
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

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.