How to check Free space in ASM diskgroups
Connect to ASM instance.
QUERY 1
select name, state, total_mb, free_mb from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB
------------------------------ ----------- ---------- ----------
DATA01 MOUNTED 4095968 1674748
RECO01 MOUNTED 3071976 1993636
VOTE MOUNTED 153588 153288
QUERY2
SELECT name, type, ceil (total_mb/1024) TOTAL_GB , ceil (free_mb/1024) FREE_GB, required_mirror_free_mb,
ceil ((usable_file_mb)/1024) FROM V$ASM_DISKGROUP;
NAME TYPE TOTAL_GB FREE_GB REQUIRED_MIRROR_FREE_MB CEIL((USABLE_FILE_MB)/1024)
------------------------------ ------ ---------- ---------- ----------------------- ---------------------------
DATA01 EXTERN 4000 1562 0 1562
RECO01 EXTERN 3000 1948 0 1948
VOTE HIGH 150 150 0 50
QUERY 3
------------
SET LINESIZE 150
SET PAGESIZE 9999
SET VERIFY off
COLUMN group_name
FORMAT a25 HEAD 'DISKGROUP_NAME'
COLUMN state FORMAT a11 HEAD 'STATE'
COLUMN type FORMAT a6 HEAD 'TYPE'
COLUMN total_mb FORMAT 999,999,999 HEAD 'TOTAL SIZE(GB)'
COLUMN free_mb FORMAT 999,999,999 HEAD 'FREE SIZE (GB)'
COLUMN used_mb FORMAT 999,999,999 HEAD 'USED SIZE (GB)'
COLUMN pct_used FORMAT 999.99 HEAD 'PERCENTAGE USED'
SELECT distinct name group_name , state state , type type ,
round(total_mb/1024) TOTAL_GB , round(free_mb/1024) free_gb ,
round((total_mb - free_mb) / 1024) used_gb ,
round((1- (free_mb / total_mb))*100, 2) pct_used from
v$asm_diskgroup;
GROUP_NAME STATE TYPE TOTAL_GB FREE_GB USED_GB PERCENTAGE USED
------------------------------ ----------- ------ ---------- ---------- ---------- ---------------
DATA01 MOUNTED EXTERN 6500 1321 5178 79.67
RECO01 MOUNTED EXTERN 3000 2252 748 24.92
VOTE MOUNTED HIGH 150 150 0 .20
