1 2 Previous Next 15 Replies Latest reply: Oct 28, 2013 12:35 PM by Hussein Sawwan-Oracle RSS

    Error is:java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number  with name "" too small"

    942633

      Hello,

       

      We are running a CM Request which is failing with the stated Error:":java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number  with name "" too small".

      Its in our one of production instance.I have checked about undo parameter.Below is the details.

       

      SQL> show parameter undo

      NAME                                 TYPE        VALUE

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

      _in_memory_undo                      boolean     TRUE

      _undo_debug_usage                    integer     2

      undo_management                      string      AUTO

      undo_retention                       integer     40000

      undo_tablespace                      string      APPS_UNDOTS1

      SQL> select max(maxquerylen) from v$undostat;

       

       

      MAX(MAXQUERYLEN)

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

                637116

       

      Please suggest what should be done to proceed further.


      Regards,

      Prabhat.

       

      Message was edited by: 942633

        1 2 Previous Next