Re: ORA-01555: snapshot too old: rollback segment number 24 with name "_SYSSMU24$" too small

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_at_yahoo.com>:
> 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
--
http://www.freelists.org/webpage/oracle-l