--It appears that before you create a non-system rollback segment that you must create a 2nd system rollback segment which can be eliminated after you create the non-system rollback segment

Is this correct ?

If so ... My Db which I inherited already went through this process at some point :-)

If I have a non-system rollback segment than its OK to go ahead and create a 2nd non-system ???

I've done a check and gotten a contention level of over the legendary 1% point that is mentioned in all the docs- although my customers are not complaining .:

=========================
ROLLBACK SEGMENT CONTENTION
=========================

If any ratio is > .01 then more rollback segments are needed

NAME WAITS GETS Ratio
------------------------------ ---------- ---------- ---------
SYSTEM 0 3408 00.00000
RBS01 395 32462 00.01217

2 rows selected.


Overall gets .v. waits...

GETS - # of gets on the rollback segment header: 35872
WAITS - # of waits for the rollback segment header: 395
The ratio of Rollback waits/gets is 1.1%

NB If ratio is more than 1%, create more rollback segments
----------------------------------------------

So ... is it so easy that I just create another non-system rollback segment that has the same features os RBS01 ??

Should I wait until people complain ?

Thanks,

Roger