I have been looking at this new database we have and seen alot of ORA-01555's in the alert log (started happening today). The database is 10.1.0.3 on Redhat Linux.
The undo_retention period is 4500
And there is ample space available for the undo tbs to extend.
The alert log points the query has been running for 1186764763s!! The query is trying to insert images into a table but surely one cannot increase the undo_retention time to match the length of query run? Is there anything that can be done to get rid of the error (i know tuning the query is one) but any others would be appreciated!
I actually increased the undo_retention to 4500, it was set to 900 orginally. Do u mean decrease the the undo in conjunction with the use to temp tables? Because i thought the solution to getting rid of ORA-01555 errors is to increase the undo_retention parameter.
Also this database is shutdown daily so i cannot understand how the query has been running for such a long time?