If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

hi,
The 2 waits are minimal and you could countinue with the same rollback segs. However since there are only 2 rollback segs, you can go ahead and create 1 or 2 more segs .
Have you checked the wraps column of the rollback segs ?

Hi Rey,
Pls note that at a time many processes/transactions can get hold of a rollback segment. This does not indicate a problem at all. As Sureshy had pointed out..only if there are more waits you may create new rollback segs.

hi vinit,
this is a parallel occurence anyway, one of the reason why you gets waits is when there are more than one processes utilizing the same rbs.
The point that I want to made is that If all your rbs have more than 1 XACTS most of the time then this surely means that you need to add more rbs.

Originally posted by reydp
The point that I want to made is that If all your rbs have more than 1 XACTS most of the time then this surely means that you need to add more rbs.

you must be joking?
a rbs supports more than one transaction, actually the extents inside a RBS supports more than one transaction, XACTS means active transaction going in each RBS, if I have 40 extents in a RBS I can perfectly have more than 1, 2, 3, 40, 80 or even more transactions concurrently depending on transaction size

If we base on strategy in a system with 200 concurrent transactions we would have to create 200 RBS?

If you see values > 0 in WAITS then you may consider adding more RBS but from the statistics pasted the wait is minimal

hi,
IF you consider adding a rollback seg for no. of values in xacts then i wonder how many rollback segs would you create if your DB has transactions in thousands.
Secondly the wait is just 1 and not 1% of the gets , which as pando pointed out is quite minimal.

What did I miss....
Oh....you guys are taking a beating on me....heehhee...

So thus this means that if all of your rollback segments
lets say just 8 and not 80 XACTS most of the time you will
not consider adding RBS?
Cause I believe if this happens it will hit your GETS and WAITS ratio down.

Anyway, I just want to consider the XACTS factors aside from GETS and WAITS......