This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 28, 2013 10:35 AM by Hussein Sawwan-Oracle RSS

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

942633 Newbie
Currently Being Moderated

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

Legend

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