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