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: Doug Gernaat <dag_at_its.msstate.edu>
Date: Tue, 30 May 2006 11:28:32 -0500
Message-Id: <s47c2c6b.024@mailhost.groupwise.msstate.edu>


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 <danielwfink_at_yahoo.com> 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
Received on Tue May 30 2006 - 11:28:32 CDT

Original text of this message

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