Database Administration (MOSC)

MOSC Banner

ORA-01555 with high undo_retention-value but short query duration

edited Jan 6, 2009 1:35AM in Database Administration (MOSC) 4 comments
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center