ORA--01555 with a query duration of 0 seconds.
Hello,
Occassionally we encounter ORA-01555's where we have undo_management set to auto and a high value for the undo_retention. Still sometimes it results in a ORA-1555 with a query duration of let's say 40 seconds, and even sometimes 0 seconds.
11-JAN-2009 12:41:37 Message: ORA-01555 caused by SQL statement below (SQL ID: 3zu8m99zp4tg8, Query Duration=0 sec, SCN: 0x0859.1aa29c59):
Undo-tablespace is 11000MB. Undo_retention is set to 14400.
It happens with Oracle9-databases and Oracle10-databases.
I started monitoring the undostat-data, but it didn't come up with special things after this time.
Any clues?
Greetings, Dick
Occassionally we encounter ORA-01555's where we have undo_management set to auto and a high value for the undo_retention. Still sometimes it results in a ORA-1555 with a query duration of let's say 40 seconds, and even sometimes 0 seconds.
11-JAN-2009 12:41:37 Message: ORA-01555 caused by SQL statement below (SQL ID: 3zu8m99zp4tg8, Query Duration=0 sec, SCN: 0x0859.1aa29c59):
Undo-tablespace is 11000MB. Undo_retention is set to 14400.
It happens with Oracle9-databases and Oracle10-databases.
I started monitoring the undostat-data, but it didn't come up with special things after this time.
Any clues?
Greetings, Dick
0