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.
123
colnamefora20col percentage 999.99SELECTname, free_mb, total_mb, free_mb/total_mb*100aspercentageFROMv$asm_diskgroup; - And to check the size and free space in ASM disks:
12345678910
setpagesize 200setlines 200setlong 1000col pathfora50colnamefora10col header_Statusfora12col read_mbfor99999.99col write_mbfor99999.99selectname, path, header_status, total_mb, free_mb, trunc(bytes_read/1024/1024) read_mb, trunc(bytes_written/1024/1024)write_mbfromv$asm_disk; - And to mount and umount ASK disk group:
123456
SQL>alterdiskgroup FRA mount;orasmcmd>mount FRASQL>alterdiskgroup FRA dismount;ORasmcmd>umount FRA
Amen Answered question 11/04/2023