IOPS和MBPS 是数据库里的2个重要指标,可以直接通过AWR报告来进行计算。
第一个部分是Load Profile:
https://www.cndba.cn/dave/article/2070
https://www.cndba.cn/dave/article/2070
IOPS = Read IO requests + Write IO requests = 2095 + 5467 = 7562
MBPS = Read IO (MB) + Write IO (MB) = 18M+151M = 169M
=[Physical read (blocks)+ Physical write (blocks)]*8k = [2320+19355] * 8k = 169M
第二个部分是Instance Activity Statistics:
https://www.cndba.cn/dave/article/2070
IOPS = physical reads total I/O requests + physical writes total I/Orequests
MBPS = physical reads total bytes + physical writes total bytes
https://www.cndba.cn/dave/article/2070
https://www.cndba.cn/dave/article/2070
计算结果和第一种方法一致。
版权声明:本文为博主原创文章,未经博主允许不得转载。
如何根据AWR报告 计算数据库的 IOPS和MBPS