重庆思庄技术分享——oracle asm下如何查看IO

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;