Re: How many rollback segments can a transaction use?

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 9 Jul 2003 16:48:48 -0700
Message-ID: <73e20c6c.0307091548.5e15e1cf@posting.google.com>

mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0307090520.ff449ae_at_posting.google.com>...
>
> I should be missing something and will greatly appreciate your insight

You are getting two rlbsegs with major activity, which are used by your two main active transactions. These may generate some dictionary management transactions (also called recursive SQL) and a number of other activities which are catered for by the other small usage of rlbseg that you see. All of these need to be able to be rolled back, hence the additional usage. You may also have other jobs going you don't know about?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Jul 09 2003 - 18:48:48 CDT