AWR可以估算出磁盘的IOPS,MBPS性能指标吗?

136156188

请教各位，AWR可以估算出磁盘的IOPS,MBPS性能指标吗?
如果AWR不能估算，是否有其他方法可以对现行生产库进行抽样测试后推算出来呢?

Maclean Liu(刘相兵

FYI


参考AWR中的Instance Activity Statistics 环节

    IOPS = “physical reads total I/O requests” + “physical writes total I/Orequests”
    MBytes/s = “physical reads total bytes” + physical writes total bytes”

physical read total IO requests        3,272,436        455.48        34.52
physical write IO requests        314,647        43.79        3.32

IOPS = “physical reads total I/O requests” + “physical writes total I/Orequests” =  455+43 = 498


physical read total bytes        3,218,786,182,144        448,007,955.58        33,956,306.25
physical write total bytes        72,372,139,008        10,073,143.17        763,483.62


MBytes/s= 448,007,955 +　10,073,143　＝　458081098bytes= 436 MB/s

大致计算其 IOPS 为 498 而 吞吐量为 436MB/s

http://t.askmaclean.com/thread-2041-1-1.html