column path format a50
column name format a25
column header_status format a15
column GR_num format 999999
column total_gb format 999
column GB format 999

select d.group_number GR_num, g.name, round(g.total_mb/1024) total_gb, path,d.name, header_status, round(d.total_mb/1024) GB
from v$asm_disk d left join v$asm_diskgroup_stat g on g.group_number=d.group_number
order by g.name,d.name
/
