Deadlock gragh/initrans value

From: Rama Sreenivas <rama_nagaraju_at_hotmail.com>
Date: 2 Apr 2003 07:17:51 -0800
Message-ID: <3d1c4f1a.0304020717.2c6da533_at_posting.google.com>


Hello,
 I have the following deadlock graph. I wanted some input as to whether the following could be resolved by increasing the INITRANS i.e whether it is an ITL related deadlock or something else...If you observe the ROWID says: no rows.
Can anyone give any suggestions?

DEADLOCK DETECTED
Current SQL statement for this session:
delete from TOTE_order where TOTE_order_id = 5336858 The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Deadlock graph:

                       ---------Blocker(s)-------- 
---------Waiter(s)---------
Resource Name          process session holds waits  process session
holds waits
TX-00060025-0000129d        17      29     X             25     131   
       S
TX-00090003-000012fc        25     131     X             17      29   
       S
session 29: DID 0001-0011-00000002	session 131: DID 0001-0019-00000002
session 131: DID 0001-0019-00000002	session 29: DID 0001-0011-00000002
Rows waited on:
Session 131: no row
Session 29: no row Received on Wed Apr 02 2003 - 17:17:51 CEST

Original text of this message