根据AWR计算IOPS与MBPS

参考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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12974804/viewspace-1062270/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12974804/viewspace-1062270/