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: get rollback info for process

Re: get rollback info for process

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: Tue, 30 May 2006 10:04:15 -0700 (PDT)
Message-ID: <20060530170415.27494.qmail@web37202.mail.mud.yahoo.com>


You can use v$transaction (v$session.taddr = v$transaction.addr) to determine which rolblack/undo segment (xidusn) that a transaction is currently using. Of course, once the transaction is over, that information is lost, so there is not really a clean method to track each undo segment that a process uses and report on it after the fact.

If the rollback segment that the process wants is not online when it tries to set the transaction, Oracle reports an error. However, the process might not be handling that error, so when it issues the next call, it gets assigned to a rollback segment according to Oracle's algorithm.

Regards,
Daniel Fink

Doug Gernaat <dag_at_its.msstate.edu> wrote: write i believe. this process contains updates/inserts/commits throughout.
this process is ran during off-peak hours. after every commit and the very beginning, "set transaction use rollback segment rbsxl1" is issued.
this process bombed one time with a failure to extend on rbs11(a small rbs).
so... where/how did it get missed? this design has issues but it's what we got
from the vendor. taking all the smaller rbs offline and putting the larger
rbs online... then running the process and changing back is not an option
for us. moving to an undo tablespace is also not an option at the moment.

thanks
-doug-

>>> Daniel Fink 5/30/2006 11:11:57 AM >>>
Doug,

Do you mean which segments the process wrote undo information, read undo information or both?

Regards,
Daniel Fink

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 30 2006 - 12:04:15 CDT

Original text of this message

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