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

    Snapshot too old issue

    948968
      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