Bad DBA 🙁

A small query to give a snapshot of your ASM disk group sizes

set lines 200
select name,
       trunc(total_mb/1024,2) as total_gb,
       trunc(free_mb/1024,2) as free_gb,
       trunc((total_mb - free_mb)/1024,2) as used_gb,
       trunc((free_mb/total_mb) * 100,2) as free_percent
  from gv$asm_diskgroup
 order by name;