Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Your opinion please...RBS
Dear Lisa
I think your problem is having too few rollback segments .
As you know Oracle shares transactions between rolback segments acc to their active transaction count.In your case
you have only one rollback segment so all transactions must share it. You can make it bigger and bigger, but you should
also think about transaction table of it, there may be congestion on the transaction table of rbs.
Therefore you should create more rbs Oracle says that rbs count should be transaction count / 4 but I think because you know your system requirements you can calculate as you wish.
Good luck
Received on Tue Dec 12 2000 - 10:41:44 CST