469,610 Members | 1,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Rollback segs,

Please see output below:

Why is there considerably more activity on RB1 compared to the rest?

Can someone please explain the stats to me, or at least point me in
the direction of some good docs on Rollback segs?

Many thanks,

Dave
NAME AC EXT RSS HWMS GETS WAIT WRITES SHRK EXTD
WRAP AVESHRNK OPTS AVEACTIVE
------ --- ---- ---- ---- ------- ----- -------------- ----- -----
----- --------- ---- ----------
RB1 0 5 20M 217M 97160 1 152,378,172 5 49 57
41345024 20M 123336104
RB2 0 5 20M 44M 57640 1 38,810,408 1 6 14
25313280 20M 13974851
RB4 0 5 20M 20M 48338 0 13,116,882 0 0 4
0 20M 1450135
RB3 0 5 20M 20M 48068 0 12,399,842 0 0 5
0 20M 1727134
------- ----- --------------
sum 251206 2 216,705,304
Jul 19 '05 #1
1 2087
br******************@hotmail.com (David Brent) wrote in
news:43**************************@posting.google.c om:
Please see output below:

Why is there considerably more activity on RB1 compared to the rest?

Can someone please explain the stats to me, or at least point me in
the direction of some good docs on Rollback segs?

Many thanks,

Dave
NAME AC EXT RSS HWMS GETS WAIT WRITES SHRK EXTD
WRAP AVESHRNK OPTS AVEACTIVE
------ --- ---- ---- ---- ------- ----- -------------- ----- -----
----- --------- ---- ----------
RB1 0 5 20M 217M 97160 1 152,378,172 5 49 57
41345024 20M 123336104
RB2 0 5 20M 44M 57640 1 38,810,408 1 6 14
25313280 20M 13974851
RB4 0 5 20M 20M 48338 0 13,116,882 0 0 4
0 20M 1450135
RB3 0 5 20M 20M 48068 0 12,399,842 0 0 5
0 20M 1727134
------- ----- --------------
sum 251206 2 216,705,304


Any single transaction will only ever use a single RBS;
therefore I'd conclude that RB1 supported a "busy" transaction.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by tkestell | last post: by
2 posts views Thread by Alice | last post: by
2 posts views Thread by Alice | last post: by
1 post views Thread by anders_tung | last post: by
3 posts views Thread by level8 | last post: by
1 post views Thread by cheesey_toastie | last post: by
2 posts views Thread by Ian Boyd | last post: by
1 post views Thread by David Brent | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.