ASM Disk group size Check

select name, total_mb, free_mb, usable_file_mb,

round(((total_mb-nvl(free_mb,0))/total_mb)*100,0) percent_used

from V$ASM_DISKGROUP_STAT;

Or

SELECT G.NAME,

sum(b.total_mb) total_mb,

sum((b.total_mb - b.free_mb)) used_mb,

sum(B.FREE_MB) free_mb,

decode(sum(b.total_mb),0,0,(ROUND((1- (sum(b.free_mb) / sum(b.total_mb)))*100, 2))) pct_used,

decode(sum(b.total_mb),0,0,(ROUND(((sum(b.free_mb) / sum(b.total_mb)))*100, 2))) pct_free

FROM

v$asm_disk b,v$asm_diskgroup g

where b.group_number = g.group_number (+)

group by g.name;