column name format a20;
column path format a20;
column mount_status format a12;
SET linesize 200;
SELECT name,
path,
group_number,
disk_number,
mount_status,
state
FROM v$asm_disk
ORDER BY group_number;
Sample Output:
Code: Select all
NAME PATH GROUP_NUMBER DISK_NUMBER MOUNT_STATUS STATE
-------------------- -------------------- ------------ ----------- ------------ --------
VOL1_0001 /dev/raw/raw2 1 1 OPENED NORMAL
VOL1_0000 /dev/raw/raw1 1 0 OPENED NORMAL