Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

V$ROLLSTAT

This view 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 ALL/DBA/USER_SEGMENTS views.

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 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