SET lines 200
SELECT name,
type,
total_mb,
free_mb,
required_mirror_free_mb,
usable_file_mb,
free_mb/total_mb*100 "% Free"
FROM V$ASM_DISKGROUP;
Sample Output:
Code: Select all
NAME TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB % Free
-------------------- ------ ---------- ---------- ----------------------- -------------- ----------
VOL1 NORMAL 6134 2178 0 1089 35.5070101