Q:
I am getting the following error in the alert log file
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