ora -01555 snapshot too old
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.
0