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