Consultar discos por Disk Group
select b.name,a.disk_number,a.name,a.failgroup,a.label,a.path,a.total_mb,b.total_mb
from V$ASM_DISK A, V$ASM_DISKGROUP B
where a.group_number=b.group_number
order by 1,2
Consultar discos por Disk Group
select b.name,a.disk_number,a.name,a.failgroup,a.label,a.path,a.total_mb,b.total_mb
from V$ASM_DISK A, V$ASM_DISKGROUP B
where a.group_number=b.group_number
order by 1,2