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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Your opinion please...RBS

Re: Your opinion please...RBS

From: Emine ATES <emineates_at_postmaster.co.uk>
Date: Tue, 12 Dec 2000 16:41:44 +0000
Message-Id: <10708.124340@fatcity.com>


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

Original text of this message

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