set pagesize 3500;
set linesize 3500;
column group_number format 999 heading group_number;
column INSTANCE_NAME format a16 heading INSTANCE_NAME;
column SOFTWARE_VERSION format a21 heading SOFTWARE_VERSION;
column COMPATIBLE_VERSION format a20 heading COMPATIBLE_VERSION;
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.INSTANCE_NAME, vd.DB_NAME, vd.group_number, vg.name name_group, vd.STATUS, vd.SOFTWARE_VERSION, vd.COMPATIBLE_VERSION
from v$asm_client vd, v$asm_diskgroup vg 
where vd.group_number = vg.group_number
order by vd.INSTANCE_NAME, vg.name;
