2 Replies Latest reply: Jul 16, 2012 5:12 AM by 948968 RSS

    Snapshot too old issue

      The oracle db for our application was recently upgraded from - 64bi to - 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.