Re: Snapshot too old
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Sun, 15 Oct 2006 21:31:55 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
