← ASM & Storage
Oracle · ASM & Storage
How to check ASM disks in Oracle
List Oracle ASM disks with path, header status, size, and read/write MB from v$asm_disk.
Tested on11g12c19c21c23ai26ai
Run connected to the ASM instance, or a database instance that can see the v$asm views.
set pagesize 2000
set lines 2000
set long 999
col path for a54
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;asmdiskv$asm_disk