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@(protected)>:
> 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