Duration 1151404820? That's like 36+ years... a bit odd, uh? :)
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
caused by SQL statement below (Query
> Duration=1151404820 sec, SCN: 0x0849.81c92aa1):