DEADLOCK DETECTED
Current SQL statement for this session:
DELETE FROM tabx WHERE col1 = :B2 AND col2 = :B1
----- PL/SQL Call Stack -----
objectlineobject
handlenumbername
c0000000700c16781400package body x
c000000070984420 245package body x2
c000000070984420 276package body x3
c00000007096b3e0 1anonymous block
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 waitsprocess session holds waits
TM-00002257-0000000041 405SX SSX 14 408SX SSX
TM-00002257-0000000014 408SX SSX 41 405SX SSX
session 405: DID 0001-0029-000026E2
session 408: DID 0001-000E-000024A7
session 408: DID 0001-000E-000024A7
session 405: DID 0001-0029-000026E2
Rows waited on:
Session 408: obj - rowid = 000021F9 - AAACH5AAJAAAAAAAAA
(dictionary objn - 8697, file - 9, block - 0, slot - 0)
Session 405: obj - rowid = 000021F9 - AAACH5AAJAAAAdMAAA
(dictionary objn - 8697, file - 9, block - 1868, slot - 0)
Information on the OTHER waiting sessions:
Session 408:
pid=14 serial=xx audsid=5586777 user: xxxx
O/S info: xxx: , ospid: 25734, machine: xxxx
program: xxxx(TNS V1-V3)
application name: xxx@xxx (TNS V1-V3), hash value=0
Current SQL Statement:
DELETE FROM tabx WHERE col1 = :B2 AND col2 = :B1
End of information on OTHER waiting sessions.
===================================================
|