This discussion is archived
12 Replies Latest reply: Nov 12, 2010 3:57 AM by 807932 RSS

ORA-01555: snapshot too old: rollback segment number

CKPT Guru
Currently Being Moderated
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 :)

Legend

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