select
inst_id, -- INST_ID NUMBER
kturdusn, -- USN NUMBER
kturdlat, -- LATCH NUMBER
kturdext, -- EXTENTS NUMBER
kturdsiz, -- RSSIZE NUMBER
kturdwrt, -- WRITES NUMBER
kturdnax, -- XACTS NUMBER
kturdget, -- GETS NUMBER
kturdwat, -- WAITS NUMBER
decode( -- OPTSIZE NUMBER
kturdopt, -1,to_number(null),kturdopt),
kturdhwm, -- HWMSIZE NUMBER
kturdnsh, -- SHRINKS NUMBER
kturdnwp, -- WRAPS NUMBER
kturdnex, -- EXTENDS NUMBER
kturdash, -- AVESHRINK NUMBER
kturdaae, -- AVEACTIVE NUMBER
decode( -- STATUS VARCHAR2(15)
bitand(kturdflg,7), 0,'ONLINE', 2,'PENDING OFFLINE', 3,'OFFLINE', 4, 'FULL', 'UNKNOWN'),
kturdcex, -- CUREXT NUMBER
kturdcbk -- CURBLK NUMBER
from
x$kturd
where
kturdsiz != 0 and bitand(kturdflg,7) != 3