Re: 01555 and select statement

niy38_at_hotmail.com wrote:
> if drop the incremental commits, I worry the udno segment will increase
> a lot,
> and ora-01555 still occur possibly.

Everyone has given you good advice, especially bdbafh's Ask Tom link. If you can rewrite the update to use plain old sql rather than the PL loop, that may also increase performance. Your undo will increase a lot, you need to test the update to see how much, and how much to increase your undo_retention - but if the performance allows it to finish in 1 day instead of 10, won't everyone be happier? Also see http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6894817116500

In other words, it is generally a mistake to configure your system without enough undo space.

jg

--
@home.com is bogus.
A Tsunami of information!  What's Shelley Winters doing here?
http://www.iastate.edu/~nscentral/news/2006/may/c6update.shtml