8.182 V$ROLLSTAT
V$ROLLSTAT
contains rollback segment statistics.
Column | Datatype | Description |
---|---|---|
|
|
Rollback segment number |
|
|
Latch for the rollback segment |
|
|
Number of extents in the rollback segment |
|
|
Size (in bytes) of the rollback segment. This value differs by the number of bytes in one database block from the value of the See Also: Oracle Database Administrator’s Guide for more information about space management for rollback segments |
|
|
Number of bytes written to the rollback segment |
|
|
Number of active transactions |
|
|
Number of header gets |
|
|
Number of header waits |
|
|
Optimal size of the rollback segment |
|
|
High watermark of the rollback segment size |
|
|
Number of times the size of a rollback segment decreases |
|
|
Number of times rollback segment is wrapped |
|
|
Number of times rollback segment size is extended |
|
|
Average shrink size |
|
|
Current size of active extents, averaged over time. |
|
|
Rollback segment status:
|
|
|
Current extent |
|
|
Current block |
|
|
The ID of the container to which the data pertains. Possible values include:
|