deadlock trace interpretation

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 4 Oct 2002 10:23:21 -0700
Message-ID: <44a19320.0210040923.52b02e78@posting.google.com>

all:
I have follwing deadlock trace file.

my question:
1. what is ddl and parse locks ?

2. how to translate object handle (c000000020a80868),

                     waiting session(c0000000044de890),
                    block session(c000000006f10a70)

  to object_id or object name and more meaningful session number ?

thnx in advance
ted chyn

---

A deadlock among DDL and parse locks is detected. This deadlock is usually due to user errors in the design of an application or from issuing a set of concurrent statements which can cause a deadlock. This should not be reported to Oracle Support. The following information may aid in finding the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object RTRAC.RYDERTRAC_EDI

---

  object   waiting  waiting       blocking blocking
  handle   session     lock mode   session     lock mode

-------- -------- -------- ---- -------- -------- ---- c000000020a80868 c0000000044de890 c000000006f10a70 S c000000004509e10 c0000 00006db8f60 X
c000000020a80a40 c000000004509e10 c00000000ab7a858 X c0000000044de890 c0000 00008835d40 S

---

• DUMP OF WAITING AND BLOCKING LOCKS ----------

  ---

  • WAITING LOCK -------------

    ---

    SO: c000000006f10a70, type: 35, owner: c000000004759ee0, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=c000000006f10a70 handle=c000000020a80868 request=S call pin=0 session pin=0 user=c0000000044de890 session=c0000000044de890 count=0 flags=[00] savepoint=5114 044 LIBRARY OBJECT HANDLE: handle=c000000020a80868 name=RTRAC.ERRORDEFINITION hash=abc79a96 timestamp=09-15-2002 03:26:53 namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0501-0711 lock=X pin=S latch=0

Received on Fri Oct 04 2002 - 12:23:21 CDT