ASM Diskspace

• disk space status (sur instance +ASM)

SELECT name, 
free_mb/1024 FREE_GB, 
total_mb/1024 TOTAL_GB, 
free_mb/total_mb*100 FREE_PERCENTAGE
FROM v$asm_diskgroup;