Snapshot too old on 9i (9.1.2)
We are getting snapshot too old on 9i . We got Undo retention = 3 hours and having undo tablespace 11 GB. Users never used more than 1GB . But we are getting Snapshot too old error. Our system tablespace size is 2gb . We got lot of objects owned by sys(Oracle finanacials 11i). Any solution??
Re: Snapshot too old on 9i (9.1.2)
Quote:
Originally posted by raghud
We are getting snapshot too old on 9i . We got Undo retention = 3 hours and having undo tablespace 11 GB. Users never used more than 1GB . But we are getting Snapshot too old error. Our system tablespace size is 2gb . We got lot of objects owned by sys(Oracle finanacials 11i). Any solution??
The error ORA-01555 is reported when the flashback data is not available anymore in the UNDO Tablespace. Just reduce a bit the UNDO_RETENTION. 3h is really a lot.