-
--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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|