DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
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-000277c7-00000000 54 103 SX 66 39 SX SSX
TX-0009000b-000a1538 66 39 X 54 103 S
session 103: DID 0001-0036-0000076B session 39: DID 0001-0042-0000148B
session 39: DID 0001-0042-0000148B session 103: DID 0001-0036-0000076B
Rows waited on:
Session 103: no row
Session 39: no row
----- Information for the OTHER waiting sessions -----
Session 39:
sid: 39 ser: 47663 audsid: 733983 user: 254/CCC flags: 0x45
pid: 66 O/S info: user: oracle, term: UNKNOWN, ospid: 20413
image: oracle@prozesscontrol01
client details:
O/S info: user: ccc, term: , ospid: 20408
machine: prozesscontrol01 program: sqlplus@prozesscontrol01 (TNS V1-V3)
application name: SQL*Plus, hash value=3669949024
current SQL:
DELETE FROM CLIENT
----- End of information for the OTHER waiting sessions -----
Information for THIS session:
----- Current SQL Statement for this session (sql_id=0rkjfc6923g96) -----
INSERT INTO CCC.DOCUMENT (ID,CREATE_LOGIN_ID,CHANGE_LOGIN_ID,PARENT_DOCUMENT_ID,CLIENT_CODE,DOCUMENTSTATUS_CODE,TEMPLATE_CODE,CREATEDATE,CHANGEDATE,CASE_ID,TITLE,NOTE,DOCUMENTHIGHLIGHT_CODE,ADDRESSEE_PARTNER_ID) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 )
В чем может быть причина взаимной блокировки?Как это исправить?