如何查到Oracle产生的IOPS?
环境是Windows2000+Oracle9.2,我想查看Oracle产生的IO负荷是否在磁盘阵列能承受的范围之内,
假设我的阵列是6万IOPS,我如何查到Oracle产生的IOPS?
谢谢
如何查到Oracle产生的IOPS?
自己再顶一下, 希望有高手能帮忙解答 ,呵呵如何查到Oracle产生的IOPS?
tryV$SESS_IO
This view lists I/O statistics for each user session. AWR中的Instance Activity Stats来计算IOPS和MBPS
IOPS = “physical reads total I/O requests” + “physical writes total I/Orequests”
MBytes/s = “physical reads total bytes” + physical writes total bytes”
页:
[1]