如何测试磁盘阵列的速度1.进入sqlplus 运行下面的脚本(这些命令用来不断的往oracle 数据库里面插入数据)SQL> connect / as sysdba;Connected.SQL> create table io_test tablespace USERS as select * from all_objects;Table created.SQL> insert into io_test select * from io_test;50198 rows created.SQL> /100396 rows created.SQL> /200792 rows created.SQL> /401584 rows created.SQL> /803168 rows created.SQL> /1606336 rows created.SQL> /2.在插入的同时，在shell 下面运行iostat来查看磁盘阵列的io速度-bash-3.00$ iostat -xn 3extended device statisticsr/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device0.0 0.0 0.5 0.1 0.0 0.0 0.0 10.6 0 0 d100.0 0.0 0.0 0.0 0.0 0.0 0.0 5.8 0 0 d110.0 0.0 0.5 0.2 0.0 0.0 0.0 12.7 0 0 d170.0 0.0 0.5 0.1 0.0 0.0 0.0 10.9 0 0 d200.0 0.0 0.5 0.2 0.0 0.0 0.0 12.5 0 0 d270.1 0.0 1.0 0.1 0.0 0.0 0.6 10.9 0 0 d300.0 0.0 0.0 0.0 0.0 0.0 0.0 5.8 0 0 d310.0 0.0 1.0 0.2 0.0 0.0 2.7 13.1 0 0 d370.0 0.0 0.0 0.0 0.0 0.0 0.0 0.1 0 0 c0t0d00.0 0.1 1.0 0.2 0.0 0.0 0.0 11.3 0 0 c1t1d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d00.0 0.1 1.0 0.2 0.0 0.0 0.0 11.5 0 0 c1t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d00.1 3.3 9.3 30.0 0.0 0.0 0.0 9.4 0 2 c2t44d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360)extended device statisticsr/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d100.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d110.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d170.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d200.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d210.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d270.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d300.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d310.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d370.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d00.0 262.8 0.0 2102.7 0.0 1.9 0.0 7.3 0 99 c2t44d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360)extended device statisticsr/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d100.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d110.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d170.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d200.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d210.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d270.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d300.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d310.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d00.3 192.3 2.7 4501.1 0.0 2.5 0.0 13.0 0 100 c2t44d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360)extended device statisticsr/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d100.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d110.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d170.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d200.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d210.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d270.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d300.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d310.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d370.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d00.0 285.0 0.0 2279.9 0.0 2.6 0.0 9.2 0 100 c2t44d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360)extended device statisticsr/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d100.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d110.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d170.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d200.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d210.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d270.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d300.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d310.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d370.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d00.0 307.0 0.0 2456.1 0.0 3.0 0.0 9.9 0 100 c2t44d00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360)其中c2t44d0就是磁盘阵列所在的卷，我们分析一下磁盘阵列由于现在数据库不停被写入数据，磁盘阵列的繁忙程度为100%,但是磁盘阵列的写速度却只保持在2M/秒左右，相当于一个本地硬盘，这说明磁盘阵列由于某些设置有问题导致磁盘读写速度非常低下。