I would start with reducing the runtime of the query. 33,219 seconds is
almost 10 hours! Reduce the run time and you reduce the need for long
undo retention. Also look at running this query against data that is not
volatile (datamart or datawarehouse for example).
Dean Paul wrote:
> I've been noticing "ORA-01555
caused by SQL statement below (Query
> Duration=33219 sec, SCN: 0x0000.5c80a509): "
> i changed undo_retention 16000 and undo tablespace is having enough
> Any suggestions are welcome.
> The table which we are running is having 39 millions of records.
> Add fun gadgets and colorful themes to express yourself on Windows
> Live Spaces