Hi all,

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!

Thanks in advance,
Chucks