V$ROLLSTAT

V$ROLLSTAT contains rollback segment statistics.

Column Datatype Description
USN NUMBER Rollback segment number
LATCH NUMBER Latch for the rollback segment
EXTENTS NUMBER Number of extents in the rollback segment
RSSIZE NUMBER Size (in bytes) of the rollback segment. This value differs by the number of bytes in one database block from the value of the BYTES column of the *_SEGMENTS view.

See Also: Oracle Database Administrator's Guide

WRITES NUMBER Number of bytes written to the rollback segment
XACTS NUMBER Number of active transactions
GETS NUMBER Number of header gets
WAITS NUMBER Number of header waits
OPTSIZE NUMBER Optimal size of the rollback segment
HWMSIZE NUMBER High watermark of the rollback segment size
SHRINKS NUMBER Number of times the size of a rollback segment decreases
WRAPS NUMBER Number of times rollback segment is wrapped
EXTENDS NUMBER Number of times rollback segment size is extended
AVESHRINK NUMBER Average shrink size
AVEACTIVE NUMBER Current size of active extents, averaged over time.
STATUS VARCHAR2(15) Rollback segment status:
  • ONLINE

  • PENDING OFFLINE

  • OFFLINE

  • FULL

CUREXT NUMBER Current extent
CURBLK NUMBER Current block