Get ASM diskgroup details - Oracle Database Script. SELECT name, free_mb, total_mb, free_mb/total_mb*100 AS percentage FROM v$asm_diskgroup;
SELECT name, free_mb, total_mb, free_mb/total_mb*100 AS percentage FROM v$asm_diskgroup;