Monday, April 8, 2019

How to check ASM disk space usage on oracle 18c RAC database ?

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

How can I restore Cassandra snapshots?