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>
Session 131: no row
Session 29: no row Received on Wed Apr 02 2003 - 17:17:51 CEST
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-00000002Rows waited on:
Session 131: no row
Session 29: no row Received on Wed Apr 02 2003 - 17:17:51 CEST