Interpetting Rollback Seg report

From: <david.jay.jackson_at_usa.net>
Date: Fri, 11 Feb 2000 22:28:53 GMT
Message-ID: <8822f0$v06$1@nnrp1.deja.com>

Greetings ---

Here is a the summary information for the Rollback Segments for one of the proudction DB's I support. 1) DB was restarted approx. 24 hrs. before this report was run, 2) DB is used as a datamart and not transaction processing, using Oracle 8.0.5. What "rules of thumb" can I use to determine if my rollback segments are setup properly?

Thanks for you help,
David Jackson

Rollback         Optium  Number Average Number
Segment            Size Shrinks Shrinks  Wraps
                                               EXTENTS
---------- ------------ ------- ------- ------ ----------------
RBS01        41,943,040       0       0     15   2
RBS02        41,943,040       0       0     15   2
RBS03        41,943,040       0       0     15   2
RBS04        41,943,040       0       0     14   2
RBS05        41,943,040       0       0     15   2
RBS06        41,943,040       0       0     16   2
RBS07        41,943,040       0       0     16   2
RBS08        41,943,040       0       0     15   2
SYSTEM                        0       0      0   2

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 16:28:53 CST