set pagesize 3500;
set linesize 3500;
column group_number format 999 heading group_number;
column name_group format a19 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 ERROR_CODE format a30 heading ERROR_CODE;
column num format 999 heading num;
column tgb format 9999.99 heading Total_GB;
column dgb format 9999.99 heading Total_GB;
column ogb format 9999.99 heading Ocuppied_total_GB;
column fgb format 9999.99 heading Free_total_GB;

select * from v$asm_operation;