How to check the size of asm diskgroup? How to check the size and free space in ASM Diskgroup and ASM disks?
meda Changed status to publish 14/04/2023
- We can use the below Query to check the size and free space in ASM diskgroup.
col name for a20 col percentage 999.99 SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;
- And to check the size and free space in ASM disks:
set pagesize 200 set lines 200 set long 1000 col path for a50 col name for a10 col header_Status for a12 col read_mb for 99999.99 col write_mb for 99999.99 select name, path, header_status, total_mb, free_mb, trunc(bytes_read/1024/1024) read_mb, trunc(bytes_written/1024/1024) write_mb from v$asm_disk;
- And to mount and umount ASK disk group:
SQL>alter diskgroup FRA mount; or asmcmd>mount FRA SQL>alter diskgroup FRA dismount; OR asmcmd>umount FRA
Amen Answered question 11/04/2023