Hi Oracle gurus,

Guys my scenario is like this:

I am on Oracle 9i with automatic undo management. I am updating
approximately 20million records per day. The problem is that it is filling
up rollback segments very quickly and terminates the process prematurely.
How best can I solve this problem and what are the parameters that I
should tune?

Albert Samatanda
Information Systems - EWZ
Tel 263-4486121/9
Fax 263-4486807
GSM 263-91222278

"To talk much and arrive nowhere is the same as climbing a tree to catch a
fish" Albert Einstein

Oracle LazyDBA home page