SQL

oracle diskgroup

select name, 
       total_mb, 
       free_mb, 
       total_mb - free_mb as used_mb, 
       round(100 * free_mb / total_mb, 2) as pct_free
from v$asm_diskgroup
order by 1;