select
USN, -- USN NUMBER
LATCH, -- LATCH NUMBER
EXTENTS, -- EXTENTS NUMBER
RSSIZE, -- RSSIZE NUMBER
WRITES, -- WRITES NUMBER
XACTS, -- XACTS NUMBER
GETS, -- GETS NUMBER
WAITS, -- WAITS NUMBER
OPTSIZE, -- OPTSIZE NUMBER
HWMSIZE, -- HWMSIZE NUMBER
SHRINKS, -- SHRINKS NUMBER
WRAPS, -- WRAPS NUMBER
EXTENDS, -- EXTENDS NUMBER
AVESHRINK, -- AVESHRINK NUMBER
AVEACTIVE, -- AVEACTIVE NUMBER
STATUS, -- STATUS VARCHAR2(15)
CUREXT, -- CUREXT NUMBER
CURBLK -- CURBLK NUMBER
from
GV$ROLLSTAT
where
inst_id = USERENV('Instance')