Re: Snapshot too old
- From: "Daniel W. Fink" <danielwfink@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Sun, 15 Oct 2006 19:37:35 -0600
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
