Hi,
DEADLOCK DETECTED
Current SQL statement for this session:
DELETE
FROM CASE_DETAIL
WHERE LOCATION_CODE = :b2
AND CASE_NUM = :b1
----- PL/SQL Call Stack -----
object line object
handle number name
499be85d8 586 procedure schema.CASE_TRANSFER
49bcc01d0 1 anonymous 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 waits process session holds waits
TM-000df32c-00000000 20 18 SX SSX 17 17 SX SSX
TM-000df32c-00000000 17 17 SX SSX 20 18 SX SSX
session 18: DID 0001-0014-00000002 session 17: DID 0001-0011-00000006
session 17: DID 0001-0011-00000006 session 18: DID 0001-0014-00000002
Rows waited on:
Session 17: no row
Session 18: no row
Information on the OTHER waiting sessions:
Session 17:
pid=17 serial=782 audsid=48994524 user: 34/<none>
O/S info: user: user1, term: , ospid: 21483, machine: asa
program: load@asa (TNS V1-V3)
application name: loada@asa (TNS V1-V3), hash value=0
Current SQL Statement:
DELETE
FROM CASE_DETAIL
WHERE LOCATION_CODE = :b2
AND CASE_NUM = :b1
End of information on OTHER waiting sessions.
Can You please confirm that this is unindexed foreign key related .
Any example where delete is involved would be great , because I saw only
update/ select for update examples .
Regards.
Greg