GV$ASM_DISK_STAT

select
d.inst_id,               -- INST_ID NUMBER
d.grpnum_kfdsk,          -- GROUP_NUMBER NUMBER
d.number_kfdsk,          -- DISK_NUMBER NUMBER
d.compound_kfdsk,        -- COMPOUND_INDEX NUMBER
d.incarn_kfdsk,          -- INCARNATION NUMBER
decode                   -- MOUNT_STATUS VARCHAR2(7)
  (d.mntsts_kfdsk, 1, 'MISSING', 2, 'CLOSED', 3, 'OPENED', 4, 'CACHED', 5, 'IGNORED', 6, 'IGNORED', 7, 'CLOSING', 'INVALID'),
decode                   -- HEADER_STATUS VARCHAR2(12)
  (d.hdrsts_kfdsk, 1, 'UNKNOWN', 2, 'CANDIDATE', 3, 'MEMBER', 4, 'FORMER', 5, 'CONFLICT', 6, 'INCOMPATIBLE', 7, 'PROVISIONED', 8, 'FOREIGN', 'INVALID'),
decode                   -- MODE_STATUS VARCHAR2(7)
  (d.mode_kfdsk, 0, 'UNKNOWN', 4, 'OFFLINE', 5, 'PROTECT', 6, 'PENDING', 7, 'ONLINE', 'INVALID'),
decode                   -- STATE VARCHAR2(8)
  (d.state_kfdsk, 1, 'UNKNOWN', 2, 'NORMAL', 3, 'FAILING', 4, 'DROPPING', 5, 'HUNG', 6, 'FORCING', 7, 'DROPPED', 8, 'ADDING', 'INVALID'),
decode                   -- REDUNDANCY VARCHAR2(7)
  (d.redun_kfdsk, 16, 'UNPROT', 17, 'UNPROT', 18, 'MIRROR', 19, 'MIRROR', 20, 'MIRROR', 21, 'MIRROR', 22, 'MIRROR', 23, 'MIRROR', 32, 'PARITY', 33, 'PARITY', 34, 'PARITY', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY', 39, 'PARITY', 'UNKNOWN'),
d.libnam_kfdsk,          -- LIBRARY VARCHAR2(64)
d.totmb_kfdsk,           -- TOTAL_MB NUMBER
d.totmb_kfdsk            -- FREE_MB NUMBER
  - d.usedmb_kfdsk,
d.asmname_kfdsk,         -- NAME VARCHAR2(30)
d.failname_kfdsk,        -- FAILGROUP VARCHAR2(30)
d.label_kfdsk,           -- LABEL VARCHAR2(31)
d.path_kfdsk,            -- PATH VARCHAR2(256)
d.udid_kfdsk,            -- UDID VARCHAR2(64)
d.product_kfdsk,         -- PRODUCT VARCHAR2(32)
d.crdate_kfdsk,          -- CREATE_DATE DATE
d.mtdate_kfdsk,          -- MOUNT_DATE DATE
d.timer_kfdsk,           -- REPAIR_TIMER NUMBER
k.read_kfkid,            -- READS NUMBER
k.write_kfkid,           -- WRITES NUMBER
k.rerr_kfkid,            -- READ_ERRS NUMBER
k.werr_kfkid,            -- WRITE_ERRS NUMBER
k.rtime_kfkid/1000000,   -- READ_TIME NUMBER
k.wtime_kfkid/1000000,   -- WRITE_TIME NUMBER
k.bytesr_kfkid,          -- BYTES_READ NUMBER
k.bytesw_kfkid           -- BYTES_WRITTEN NUMBER
from
x$kfdsk_stat d,
x$kfkid k 
where
d.mntsts_kfdsk != 0 and d.kfkid_kfdsk = k.idptr_kfkid (+)
home |  up  |  mailbox