Re: How many rollback segments can a transaction use?

On 9 Jul 2003 16:48:48 -0700, Nuno Souto <wizofoz2k_at_yahoo.com.au> wrote:

> 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
>

Nuno's got it in one.

Put it another way: v$transaction only reports *user* transactions, not the many, many others that might be taking place recursively on the data dictionary. V$rollstat, however, reports all rollback activity without distinction.

~QM Received on Thu Jul 10 2003 - 02:01:00 CDT