ASM Disk Usage

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