ASM Query to check diskspace as SYSASM By Shadab Mohammad • Aug 14, 2014 • No comments set lines 999 select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as "Total Space in TB" ,FREE_MB/1024/1024 as "Free Space in TB" ,DATABASE_COMPATIBILITY from v$asm_diskgroup; Category: Uncategorized Tags: 10g • 11g • 12c • ASM • Check • Disk Space • oracle