12 Replies Latest reply: Nov 12, 2010 5:57 AM by 807932 RSS

    ORA-01555: snapshot too old: rollback segment number

    CKPT
      Hi Experts,

      Environment: Oracle 11gR1

      Undo tbs details:-
      ~~~~~~~~~~~~
      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      undo_management string AUTO
      undo_retention integer 4000
      undo_tablespace string UNDOTBS1

      UNDOTBS size : 40 GB
      ORA-01555 caused by SQL statement below (SQL ID)
      and i checked maximum length running query : < 1400
      Any one suggest me how to avoid i gone through with metalink note *ORA-01555 "Snapshot too old" - Detailed Explanation [ID 40689.1]*
      still same errors.

      Highly appriciate for right answers.
      Thanks :)