V$SESS_IO
This view lists I/O statistics for each user session.作者: lusklusklusk 時間: 2016-02-05 13:59
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”