ORA-01555 with high undo_retention-value but short query duration
Hello,
Can't find anywhere a solution for this so I'll try it here:
We have a 9.2.0.5-database running. Value undo_retention is at 86400. Occassionally we are experiencing ORA-01555 with query durations longer than that, but also shorter (e.g. 43 seconds).
UNDO-tablespace is 57GB and an undo_stats-query says that the size of the UNDO-tablespace should be around 1MB.
Currently there is around 1GB in use after startup of the database about 1 hour ago (offline backup on this testdatabase). Until now it is quite OK, but about once a day we are experiencing these ORA-1555's with a short query duration.
Can't find anywhere a solution for this so I'll try it here:
We have a 9.2.0.5-database running. Value undo_retention is at 86400. Occassionally we are experiencing ORA-01555 with query durations longer than that, but also shorter (e.g. 43 seconds).
UNDO-tablespace is 57GB and an undo_stats-query says that the size of the UNDO-tablespace should be around 1MB.
Currently there is around 1GB in use after startup of the database about 1 hour ago (offline backup on this testdatabase). Until now it is quite OK, but about once a day we are experiencing these ORA-1555's with a short query duration.
0