5 Replies Latest reply: Nov 22, 2013 11:04 AM by Hussein Sawwan-Oracle RSS

    ORA-01555 with ORA-02063 when submitted Concurrent  Requests

    942633

      Hello,

       

      My development team has reported some CM Requests got failed with some errors.When i checked the request log file i saw :java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-02063: preceding line from EIHFDM  .Could you please help me out this to solve this issue.

      We are on Oracle Database 10g Release 10.2.0.5.0 - 64bit

      Application 11.5.10

       

      I have checked the UNDO Parameter values

       

      ACTUAL UNDO SIZE (MEGS) UNDO RETENTION (Secs)                OPTIMAL UNDO RETENTION (Secs)

      ------------------------------------------- ------------------------------------------------------- -----------------------------

                                       304849                               40000                4860

       

      Thanks,

      Prabhat.