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