Oracle 8.16 Deadlock

From: Peter Lasner <plasner_at_de.imshealth.com>
Date: Thu, 10 Jan 2002 13:31:41 +0100
Message-ID: <3c3d8bff_4@news2.prserv.net>

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 Thu Jan 10 2002 - 06:31:41 CST