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