V$ROLLSTAT
This view contains rollback segments statistics.
Fields
The most relevant view fields are as follows:
USN
: The rollback segment numberLATCH
: The latch for the rollback segmentEXTENTS
: The number of extents in the rollback segmentRSSIZE
: The size of the rollback segment in bytesWRITES
: The number of bytes written to the rollback segmentXACTS
: The number of active transactionsGETS
The number of header getsWAITS
: The number of header waitsSTATUS
: The rollback segment status, it can beONLINE
,OFFLINE
,PENDING OFFLINE
, orFULL
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.