如何测试磁盘阵列的速度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 3 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.0 0.5 0.1 0.0 0.0 0.0 10.6 0 0 d10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.8 0 0 d11 0.0 0.0 0.5 0.2 0.0 0.0 0.0 12.7 0 0 d17 0.0 0.0 0.5 0.1 0.0 0.0 0.0 10.9 0 0 d20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.6 0 0 d21 0.0 0.0 0.5 0.2 0.0 0.0 0.0 12.5 0 0 d27 0.1 0.0 1.0 0.1 0.0 0.0 0.6 10.9 0 0 d30 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.8 0 0 d31 0.0 0.0 1.0 0.2 0.0 0.0 2.7 13.1 0 0 d37 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.1 0 0 c0t0d0 0.0 0.1 1.0 0.2 0.0 0.0 0.0 11.3 0 0 c1t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d0 0.0 0.1 1.0 0.2 0.0 0.0 0.0 11.5 0 0 c1t0d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d0 0.1 3.3 9.3 30.0 0.0 0.0 0.0 9.4 0 2 c2t44d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360) extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d11 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d17 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d21 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d27 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d30 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d31 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d37 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d0 0.0 262.8 0.0 2102.7 0.0 1.9 0.0 7.3 0 99 c2t44d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360) extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d11 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d17 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d21 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d27 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d30 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d31 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d37 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t3d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t0d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t5d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t4d0 0.3 192.3 2.7 4501.1 0.0 2.5 0.0 13.0 0 100 c2t44d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nmser1:vold(pid360) extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d11 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 d17 0.0 0.0 0.0 0.0 0.0 0.0 0.0