********************************************************** * Description: SQL for Checking ASM Diskgroup Utilization * Compatiablity: RDBMS 10g, 11g, 12c * Date: 17:55 PM EST, 01/16/2017 ********************************************************** <1> Checking free space on ASM diskgroup or regular file system: | |__ SQL> select name,round((free_mb/1024),0) FREE_GB,round((total_mb/1024),0) TOTAL_GB,round(((total_mb/1024) - (free_mb/1024)),0) "USED_GB", round(free_mb/total_mb*100,0) "FREE_%" from v$asm_diskgroup; NAME FREE_GB TOTAL_GB USED_GB FREE_% ------------------------------ ---------- ---------- ---------- ---------- GROUP2 56 245 189 23 GROUP1 67 300 233 22
Your Comments