SQL> select group_number,name,state,type,total_mb as "TOTAL(MB)",
2 free_mb as "FREE(MB)" ,round(free_mb/total_mb,4)*100 as "FREE(%)"
3 from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TYPE TOTAL(MB) FREE(MB) FREE(%)
------------ ----- ---------- ------- ---------- ---------- ----------
1 DG1 MOUNTED EXTERN 1000 679 67.9
2 DG2 MOUNTED EXTERN 1000 679 67.9
3 DG3 MOUNTED EXTERN 9000 1116 14.82
5 DG5 MOUNTED NORMAL 6000 5074 84.57
4 DG4 MOUNTED EXTERN 5000 4740 98.56
|