Zane Appel's Oracle Cookbook: Show disk space utilization for ASM


column name     heading 'Disk|Group Name'
column type     heading 'Type'
column totalGB  heading 'Total(GB)'
column freeGB   heading 'Free(GB)'
column usableGB heading 'Usable(GB)'

select  name, 
        type, 
        total_mb / 1024         totalGB, 
        free_mb / 1024          freeGB, 
        usable_file_mb / 1024   usableGB
from    v$asm_diskgroup;

Example:


Disk
Group Name     Type   Total(GB)     Free(GB)     Usable(GB)
-------------- ------ ------------- ------------ -------------------
PRDARCG        EXTERN    649.905273        299.5               299.5
PRDDATG        EXTERN    3099.55273   384.307617          384.307617
PRDREDG        EXTERN    29.9238281   24.8271484          24.8271484