关于statspack的rollback segment问题

[复制链接]
查看11 | 回复0 | 2008-1-2 17:35:53 | 显示全部楼层 |阅读模式
Rollback Segment Stats for DB: CMPRInstance: CMPR1Snaps: begin_snap -end_sna
->A high value for "Pct Waits" suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
managment, as RBS may be dynamically created and dropped as needed
Trans Table Pct Undo Bytes
RBS NoGetsWaits WrittenWrapsShrinksExtends
------ -------------- ------- --------------- -------- -------- --------
1861,345.00.00 941,396100
1871,516.00.00 1,015,042100
1881,522.00.00 917,416100
1891,465.00.00 720,810100
1901,255.00.00 749,704100
1911,263.00.00 877,660100
1921,373.00.07 849,180100
WrapsShrinksExtends
这三个是什么意思?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行