column path format a20 set lines 135 set pages 50 SQL> SELECT PATH, GROUP_NUMBER GROUP_#, DISK_NUMBER DISK_#, MOUNT_STATUS,HEADER_STATUS, STATE, TOTAL_MB, FREE_MB FROM V$ASM_DISK ORDER BY GROUP_NUMBER; PATH GROUP_# DISK_# MOUNT_S HEADER_STATU STATE TOTAL_MB FREE_MB -------------------------------- ---------- ---------- ------- ------------ -------- ---------- ---------- /dev/rhdisk10 1 0 CACHED MEMBER NORMAL 112001 4793 /dev/rhdisk8 1 7 CACHED MEMBER NORMAL 112001 4629 /dev/rhdisk9 1 8 CACHED MEMBER NORMAL 112001 4624 /dev/rhdisk11 1 1 CACHED MEMBER NORMAL 112001 4631 /dev/rhdisk12 1 2 CACHED MEMBER NORMAL 112001 4627 /dev/rhdisk13 1 3 CACHED MEMBER NORMAL 112001 4626 /dev/rhdisk15 1 12 CACHED MEMBER NORMAL 112001 4626 /dev/rhdisk16 1 9 CACHED MEMBER NORMAL 112001 4630 /dev/rhdisk17 1 10 CACHED MEMBER NORMAL 112001 4629 /dev/rhdisk18 1 11 CACHED MEMBER NORMAL 112001 4628 /dev/rhdisk19 1 13 CACHED MEMBER NORMAL 112001 4628 PATH GROUP_# DISK_# MOUNT_S HEADER_STATU STATE TOTAL_MB FREE_MB -------------------------------- ---------- ---------- ------- ------------ -------- ---------- ---------- /dev/rhdisk20 1 14 CACHED MEMBER NORMAL 112001 4626 /dev/rhdisk21 1 15 CACHED MEMBER NORMAL 112001 4626 /dev/rhdisk22 1 16 CACHED MEMBER NORMAL 112001 4627 /dev/rhdisk23 1 17 CACHED MEMBER NORMAL 112001 4629 /dev/rhdisk24 1 18 CACHED MEMBER NORMAL 112001 4629 /dev/rhdisk5 1 4 CACHED MEMBER NORMAL 112001 4622 /dev/rhdisk6 1 5 CACHED MEMBER NORMAL 112001 4631 /dev/rhdisk7 1 6 CACHED MEMBER NORMAL 112001 4624 /dev/rhdisk14 2 0 CACHED MEMBER NORMAL 51200 35813 2 1 MISSING UNKNOWN FORCING 0 0 21 rows selected. |
ASM QUICK REF >