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