Re: ORA-01555: snapshot too old: rollback segment number 24 with name "_SYSSMU24$" too small
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jun 2006 21:51:43 +0200
Duration 1151404820? That's like 36+ years... a bit odd, uh? :)
Anyway, ORA-1555 is often thrown regardless space availability in UNDO
tablespace. You can get it any time for read only transaction (or
single select) after it's running for retention_period time. Select
requires read consistent image of blocks and those are reconstructed
from UNDO info. UNDO info is kept for undo retention period. As soon
as you reach it - chances are you hit ORA-1555 on any more or less
often updatable table.
And yet another reason to delete this infamous job ASAP!
2006/6/27, arul kumar <arul76_2000@xxxxxxxxx>:
I have this recent error in alert log coming from the
stats update job. Though the SQL is given partly, not
able to find the EXACT database object that had
problem. Any clue?
..
....
Tue Jun 27 03:40:20 2006
ORA-01555 caused by SQL statement below (Query
Duration=1151404820 sec, SCN: 0x0849.81c92aa1):
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
