**********************************************************
* 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