本文详细介绍了 V$ROLLSTAT 视图中包含的回滚段统计信息，包括回滚段编号、加锁情况、扩展次数等关键指标。
V$ROLLSTAT
V$ROLLSTAT 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 theBYTES column of the *_SEGMENTS view. 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 the 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 |
扫一扫
280
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
