Re: Oracle 8.16 Deadlock

From: Stefan <sroesch3_at_attbi.com>
Date: Fri, 11 Jan 2002 07:29:49 GMT
Message-ID: <Nvw%7.8394$JF.82139@rwcrnsc52.ops.asp.att.net>

Hi Peter,

will be interesting to see the trace file to have a look at the state objects. It may also make sense to create a process state dump if none is in the trace file

Regards
Stefan

Peter Lasner wrote:

> Does someone know any circumstances so that one session is blocking itself
> ? The trace says:
> ORA-04020: deadlock detected while trying to lock object
> T49PDGI.PDGI_COUNTRIES
> --------------------------------------------------------
> object waiting waiting blocking blocking
> handle session lock mode session lock mode
> -------- -------- -------- ---- -------- -------- ----
> 3d892524 3b643688 3bb2b8dc X 3b643688 38dbcae0 S
>
> I use Oracle 8.16 on AIX
> Thank you in advance
Received on Fri Jan 11 2002 - 01:29:49 CST