← 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