Rollback segs,

[David Brent]

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

[Ana C. Dent]

Re: Rollback segs,

brentmeistercom edian@hotmail.c om (David Brent) wrote in
news:43d09671.0 407130054.4b92f 0d0@posting.goo gle.com:

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.