Query to find ASM Error details.

Description:

This script is used for finding ASM error details on ASM disk.

script:

select
io.inst_id
, dg.name diskgroup_name
, io.disk_number
, d.name disk_name
–, d.label
, d.read_errs
, d.write_errs
, d.path
from gv$ASM_DISK_IOSTAT io
join gv$asm_diskgroup dg on dg.inst_id = io.inst_id
and dg.group_number = io.group_number
join gv$asm_disk d on d.inst_id = io.inst_id
and d.group_number = io.group_number;