-- shows the ASM disks of each ASM diskgroup
-- for use in ASM

set linesize 132
set pagesize 999

col disk_name      for a25
col diskgroup_name for a20
col total          for a6
col path           for a50

select
vad.name "DISK_NAME",
vag.name "DISKGROUP_NAME",
vad.disk_number,
vad.total_mb,
vad.path
from
v$asm_disk vad,
v$asm_diskgroup vag
where 1=1
and vad.group_number = vag.group_number(+)
order by vag.name, vad.name;