V$asm_disk_stat
Querying ASM Disk Information in Oracle
Jan 7, 2024 / · 6 min read · Oracle ASM Oracle Disk Information Storage Management v$asm_disk v$asm_disk_stat v$asm_diskgroup v$asm_file v$asm_operation ·Querying ASM Disk Information in Oracle A disk group that reports plenty of free space can still be one disk failure away from trouble, and a LUN the storage team says is ready can still be invisible to ASM. Both show up in one query against v$asm_disk: the per-disk free space, and the group 0 rows for disks not yet in …
Read More