[Oracle Script] ASM Disk Groups Used

select name,sector_size,block_size,allocation_unit_size,state,type,total_mb,free_mb,(total_mb-free_mb) "used_mb",round((total_mb-free_mb)/total_mb,4)*100 "Used Ratio"
from v$asm_diskgroup;