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

Home -> Community -> Usenet -> c.d.o.server -> Re: How many rollback segments can a transaction use?

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

Original text of this message

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