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