ORACLE ASM io计算方法介绍

ASM的io计算无法使用操作系统命令iostat获取，oracle提供了二中方法获取IO信息

方法一、ASMCMD管理命令iostat来获取磁盘信息

ASMCMD> iostat 5

Group_Name  Dsk_Name      Reads         Writes

CRSDG       CRSDG_0000    6553.60       18022.40

DATA1DG     DATA1DG_0000  117642035.20  261120.00

FRADG       FRADG_0000    0.00          434790.40

read和write的单位都是bytes，可以简单计算磁盘组DATA1DG是0.1M/s

方法二、asm实例中的v$asm_disk_stat来获取信息

select group_number, disk_number, name, path, reads, writes, read_errs, write_errs, read_time, write_time, bytes_read, bytes_written

from v$asm_disk_stat

where group_number>0

order by group_number, disk_number;

GROUP_NUMBER     DISK_NUMBER   NAME                        PATH                           READS             WRITES    READ_ERRS     RITE_ERRS  READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN

————                    ———–                     —————    ————————-                   ———-        ———- –          ——–               ———-          ———            ———-            ———               ————-

           1                     0                                 CRSDG_0000      /dev/mapper/mpathb          19968908      8685356          0                 0                    11279.0599   3914403.55    3.4096E+11    6.0110E+11

           2                    0                                  DATA1DG_0000    /dev/mapper/mpathg        1783559199    509151187          0          0                    7861109.58     91475210.    1 2.7736E+14    1.1930E+13

           4                    0                                 FRADG_0000      /dev/mapper/mpaths          30868619       313394262          0             0                    6467271.64    24174946.3   1.0511E+13    1.3815E+13

写入速度：BYTES_WRITTEN / WRITE_TIME

读取速递：BYTES_READ  / READ_TIME