Re: Rollback segs,
Date: Wed, 14 Jul 2004 01:11:10 GMT
Message-ID: <Xns9525B90016900SunnySD_at_68.1.17.6>
brentmeistercomedian_at_hotmail.com (David Brent) wrote in news:43d09671.0407130054.4b92f0d0_at_posting.google.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. Received on Wed Jul 14 2004 - 03:11:10 CEST