GV$ROLLSTAT definition in Oracle Database 11.2
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,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

home |  up