Show ASM Disk Group Size
Posted: Tue Jan 31, 2012 11:31 am
To show show disk space usage,
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:
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