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, vd.mount_status mount_status, vd.mode_status mode_status, vd.state state, vd.name name_disk,vd.total_mb/1024 dgb, vd.path path 
from v$asm_disk vd
order by vd.group_number, vd.NAME;