asm_diskgroups_free
select name,decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1) Redundancy,REQUIRED_MIRROR_FREE_MB, (total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Total_MB, ((free_mb - REQUIRED_MIRROR_FREE_MB)/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Free_MB, ((free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1))/(total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)))*100 "%Free" from v$asm_diskgroup;