Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 148 of 211
This view contains rollback segment statistics.
Column | Datatype | Description |
---|---|---|
|
|
Rollback segment number |
|
|
Number of extents in rollback segment |
|
|
Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the See Also: Oracle9i Database Administrator's Guide. |
|
|
Number of bytes written to rollback segment |
|
|
Number of active transactions |
|
|
Number of header gets |
|
|
Number of header waits |
|
|
Optimal size of rollback segment |
|
|
High water mark of 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 |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|