Run the following on any database associated with the relevant ASM instance, or directly on the ASM instance, to see ASM disk usage.
col unbalanced form a10
COL TOTAL_GB FORM 99999.999999
COL USED_GB FORM 99999.999999
COL FREE_GB FORM 99999.999999
COL USABLE_FILE_GB FORM 99999.999999
set pages 9999 lines 200
select NAME,
GROUP_NUMBER,
TOTAL_MB/1024 TOTAL_GB,
(TOTAL_MB-FREE_MB)/1024 USED_GB,
FREE_MB/1024 FREE_GB,
USABLE_FILE_MB/1024 USEABLE_FILE_GB,
(FREE_MB/1024) / (TOTAL_MB/1024) * 100 perc_free,
OFFLINE_DISKS
-- UNBALANCED
from v$asm_diskgroup
order by NAME;
NAME Total GB Used GB Free GB % Used % Free
------------- ---------- ---------- ---------- ---------- ----------
ARCHIVE_DG 6565.699 6105.07715 460.62207 92.984 7.016
ARCHIVE_DG_02 4000.609 3302.39258 698.2168 82.547 17.453
DW_DG 6844.102 6424.3291 419.77246 93.867 6.133
WEBLOGS_DG 5248.395 4000.65332 1247.74121 76.226 23.774
