ORA-1555 error when query duration less than undo retention

Q:
I am getting the following error in the alert log file



Thu Oct 18 05:27:20 2012
ORA-01555 caused by SQL statement below (SQL ID: fphc75pmdyjpb, Query Duration=4040 sec, SCN: 0x056d.b3393d60):

My undo retention is 6300 seconds and undo management is auto. Undo datafile is auto extensible and has not reached maxbytes. 

What may be the reason for ORA-1555 error when query duration less than undo retention?

A:
It is an unsolved bug:  Bug 8231583 
Creating a new undo tablespace and dropping the old one is the temporary work around.
Read more about this in the MOS document below:



No comments:

Post a Comment