How to check free space in ASM

1. Connect to asm instance:

select name, state, total_mb, free_mb from v$asm_diskgroup;

NAME       STATE     TOTAL_MB FREE_MB

—————————— ———– ———- ———-

ORADATA MOUNTED 65536      53439

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)

ORACLE_DATA1  EXTERN         466 236           0            236

ORACLE_FLASH1 EXTERN         131  124           0            124

ORACLE_FLASH2 EXTERN         10 9 0 9

2. Using Grid Control

Go to asm host and select asm instance. Go Administration tab and input asm administration password:

3. Using ASMCMD tool

Make sure to setup ORACLE_SID and ORACLE_HOME environment variables to ASM instance.

-bash-3.2$ asmcmd -p

ASMCMD [+]>; du

Used_MB Mirror_used_MB

12011 12011

ASMCMD [+] >;

or run

lsdg command

State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name

MOUNTED EXTERN N N 1024 4096 1048576 40960 37628 0 37628 0 ORADATA/

MOUNTED EXTERN N N 1024 4096 1048576 32768 32675 0 32675 0 ORADATA1/