Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Rollback segs,

Rollback segs,

From: David Brent <brentmeistercomedian_at_hotmail.com>
Date: 13 Jul 2004 01:54:34 -0700
Message-ID: <43d09671.0407130054.4b92f0d0@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
Received on Tue Jul 13 2004 - 03:54:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US