V$ROLLSTAT

最新推荐文章于 2021-08-09 00:06:44 发布

EVISWANG

最新推荐文章于 2021-08-09 00:06:44 发布

阅读量734

点赞数

CC 4.0 BY-SA版权

分类专栏： v$ package

本文链接：https://blog.youkuaiyun.com/EVISWANG/article/details/50721188

9 篇文章

订阅专栏

本文详细介绍了 V$ROLLSTAT 视图中包含的回滚段统计信息，包括回滚段编号、加锁情况、扩展次数等关键指标。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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