How check ASM space usage on oarcle 18c database ?

Question : How check ASM space usage on oarcle 18c database ?

Answer : Use below query to get ASM space usage on oracle database.

Query:
select group_number, name, block_size state, (total_mb/1024) total_GB,(free_mb/1024) free_GB from v$asm_diskgroup;

output:
SQL> select group_number, name, block_size state, (total_mb/1024) total_GB,(free_mb/1024) free_GB from v$asm_diskgroup;

GROUP_NUMBER NAME            STATE   TOTAL_GB    FREE_GB
------------ ---------- ---------- ---------- ----------
           1 ARCH             4096 1000.14844 899.109375
           2 DATA             4096 5500.81641 743.882813