Re: Snapshot too old

Dean,

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).

Regards,
Daniel Fink

Dean Paul wrote:
> Hi,
> 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
> space.
> Any suggestions are welcome.
> The table which we are running is having 39 millions of records.
> Thx
>
> _________________________________________________________________
> Add fun gadgets and colorful themes to express yourself on Windows
> Live Spaces
> http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://www.get.live.com/spaces/features
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l