Question : How to check ASM disk space usage on oracle 18c RAC database
Answer : By using below query you will get ASM disk space usage
Query:
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 261.183594
2 DATA 4096 6500.96484 1371.67578
No comments:
Post a Comment