Database Administration (MOSC)

MOSC Banner

ora -01555 snapshot too old

edited Mar 29, 2010 9:26AM in Database Administration (MOSC) 8 commentsAnswered
 We are using undo tablespace auto management. Recently, I found ora-01555 snapshot too old error in the alert log. The current undo retention is set to 3 hours and undo space size is set to 8GB. In the error message, it shows Query Duration=237401. Does this means that I should increase my undo retention or should I increase the undo tablespace size? Please advice. By the way, the version I have is 10.2.0.3 on solaris 9. Thanks.

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