重庆思庄Oracle、Redhat认证学习论坛

标题: oracle asm下如何查看IO [打印本页]

作者: jiawang 时间: 2024-9-13 19:10
标题: oracle asm下如何查看IO

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

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

ASMCMD> iostat 5

Group_Name  Dsk_Name  Reads          Writes
DATA       DATA01 10975699823616  9430089424896
DATA       DATA02 23240008613888  10401269573632
DATA       DATA03 17543796716544  9478042163712
DATA       DATA04 18260405507584  10737774110208
DATA       DATA05 31146707814400  9374318644224
DATA       DATA06 17284726155264  9867123035136
DATA       DATA07 12121124231680  9439979880448
DATA       DATA08 20921362952192  9419341006848
DATA       DATA09 29592159839232  10762434184192

方法二、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;