GV$ROLLSTAT

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, 127), 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, 127) != 3
home |  up  |  mailbox