Oracle ASM Disk Overview
I’ve wrote a simple SQL script to list all ASM disks with state, size and their diskgroups, if any.
set pages 5000 lines 180
set heading on
set feedback off
set serveroutput on
col LABEL for a28
col DISKGROUP for a9
col STATUS for a9
col TOTAL for a11
col MOUNT_STATE for a11
exec dbms_output.put_line('---');
exec dbms_output.put_line('--- DISK OVERVIEW');
exec dbms_output.put_line('---');
SELECT
D.LABEL||' ('||D.NAME||')' LABEL,
(SELECT
NAME
FROM
V$ASM_DISKGROUP
WHERE
GROUP_NUMBER=D.GROUP_NUMBER)
DISKGROUP,
D.STATE STATUS,
lpad(D.TOTAL_MB/1024,6)||' GB' TOTAL,
D.MOUNT_STATUS MOUNT_STATE
FROM
V$ASM_DISK D
ORDER BY 2;
exec dbms_output.put_line('---');
set feedback on
The output looks as follow:
--- --- DISK OVERVIEW --- LABEL DISKGROUP STATUS TOTAL MOUNT_STATE ---------------------------- --------- --------- ----------- ----------- ORAASM1 (ORAASM1) DG1 NORMAL 99.984 GB CACHED ORAASM3 (ORAASM3) DG1 NORMAL 99.984 GB CACHED ORAASM5 (ORAASM5) DG1 NORMAL 99.984 GB CACHED ORAASM4 (ORAASM4) DG1 NORMAL 99.984 GB CACHED ORAASM2 (ORAASM2) FRA1 NORMAL 99.984 GB CACHED ORAASM6 () NORMAL 0 GB CLOSED ---