Hi,

It looks like you are running out of space in Undo tablespace, the solution is to increase the size of Undo tablespace. How much to increase depends on undo information generated per second multiplied by Undo retention time. You can use information available from V$UNDOSTAT to calculate it.

Hope it helps,

- Niranjan



-----Original Message-----
From: asamatanda
[mailto:oracledba-ezmlmshield-x39898721.[Email address protected]
Sent: Friday, December 03, 2004 12:43 PM
To: LazyDBA Discussion
Subject: Rollback segments Filling up


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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page