SQL> select name,total_mb,free_mb, (free_mb/total_mb)*100 "%Free" from v$asm_diskgroup;
NAME TOTAL SIZE(GB) FREE SIZE (GB) %Free
------------ -------------- -------------- -------------------------------------------------------
CRS 19,085 18,689 97.925072
DATA 19,085 17,397 91.1553576
FRA 23,846 23,751 99.6016103
ARCH 23,846 23,705 99.4087059
Enjoy Learning.....
