Re: get rollback info for process

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

Other related posts: