Re: Snapshot too old

On 10/15/2006 09:02:48 PM, 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

Might I inquire what in the world has motivated you to set the undo retention to 16000 when query duration was reported as 33219 seconds at the moment of error? The meaning of undo retention is the number of seconds that a query can execute without receiving ORA-1555. I would have set the maximum query duration to 65536. Worse yet, you should have set undo retention to a nice round number, something like 16384, definitely not 16000. Remember, there are only 10 types of people: those who understand binary and those who do not.

-- 
Mladen Gogala
http://www.mladen-gogala.com

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