Database Administration (MOSC)

MOSC Banner

ORA--01555 with a query duration of 0 seconds.

edited Feb 13, 2009 7:33AM in Database Administration (MOSC) 4 commentsAnswered
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

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