This discussion is archived
2 Replies Latest reply: Jul 16, 2012 3:12 AM by 948968 RSS

Snapshot too old issue

948968 Newbie
Currently Being Moderated
HI
The oracle db for our application was recently upgraded from 10.2.0.4.0 - 64bi to 10.2.0.5.0 - 64bi.
We have a long running MV process (approx 30-35 hours) in our application. These MVS are referesed from within shell scripts.
After the upgradation, we have started recieving SNAPshot too old error after running the MV refresh. The job gets failed after throwing snapshot too old error.
The current setting of undo retention paramters is 432000 (which is 120 hours).

If we try to run the process during weekends the same executes without any error.

Can someone help me in identifying RCA of this issue? Or is it some bug in oracle.

Regards
Tarun

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points