---oracle io一些参数----
http://docs.oracle.com/cd/E11882_01/server.112/e25513/stats002.htm#i375475
SQL> select * from v$statname where name like '%phy%IO%' and name not like '%cell%' or name like '%phy%multi%' order by name;
STATISTIC# NAME CLASS STAT_ID
---------- ---------------------------------------------------------------- ---------- ----------
44 physical read total IO requests 8 3343375620 -- 单或多块读的io次数
45 physical read total multi block requests 8 2007302071 --多块读的io次数
48 physical write total IO requests 8 1315894329 --单或多块写的io次数
49 physical write total multi block requests 8 3540174003 --多块写的io次数
几个小概念:
1,iops= read iops + write iops
2,iops分为单块读(写)的iops及多块读(写)的iops
3,上述参数可以根据上述的统计相减即得
4,测算oracle iops,即跑业务应用压力测试,上述的统计值根据时间差相减;即可得到各参数的iops
5,mbps 为每秒的读写的数据大小,也是分为每秒读的数据大小 和 每秒写的数据大小
6,mbps