Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot too old

Re: Snapshot too old

From: Daniel W. Fink <danielwfink_at_yahoo.com>
Date: Sun, 15 Oct 2006 19:37:35 -0600
Message-ID: <4532E25F.1050300@yahoo.com>


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
Received on Sun Oct 15 2006 - 20:37:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US