set pagesize 3500;
set linesize 3500;
column group_number format 999 heading group_number;
column name_group format a16 heading name_group;
column name_disk format a21 heading name_disk;
column state format a20 heading State;
column mount_status format a15 heading mount_status;
column mode_status format a15 heading mode_status;
column path format a30 heading path;
column num format 999 heading num;
column tgb format 9999.99 heading total_GB;
column dgb format 9999.99 heading total_GB;
column fgb format 9999.99 heading Free_total_GB;

select vd.group_number group_number, vg.state state, vg.name name_group, vg.total_mb/1024 tgb,vd.disk_number num , vd.name name_disk,
vd.total_mb/1024 dgb, vd.path path from v$asm_disk vd, v$asm_diskgroup vg 
where vd.group_number = vg.group_number order by vg.GROUP_NUMBER, vd.NAME;