* ** Service name :( SYS $ USERS) 01:03:47. 744
* ** Session id: (997.178) 01:03:47. 744
Deadlock detected (ORA-00060)
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is
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
TX-005d002f-000046dd 113 997X182 786 X
TX-004d0026-00009b4e 182 786X113 997 X
Session 997: DID 0001-0071-00000006session 786: DID 0001-00B6-0000064E
Session 786: DID 0001-00B6-0000064Esession 997: DID 0001-0071-00000006
Rows waited on:
Session 786: obj-rowid = 0002D33A-aaatm 6aadaaaj9babo
(Dictionary objn-185146, file-29, block-40769, slot-78)
Session 997: obj-rowid = 000527D6-AABSfWAAdAACmKAAAe
(Dictionary objn-337878, file-29, block-680576, slot-30)
Information on the OTHER waiting sessions:
Session 786:
Pid = 182 serial = 10783 audsid = 64898626 user: 96/GALT
O/S info: user: batch, term:, ospid: 23674, machine: v490c1-app
Program: sqlplus @ v490c1-app (TNS V1-V3)
Application name: SQL * Plus, hash value = 3669949024
Current SQL Statement:
Delete from ana a where exists (SELECT 1 FROM (SELECT LOCATOR_ID FROM (select t. LOCATOR_ID, rownum rn from temp t) where rn>: B2 and rn <=: B1) B WHERE. LOCATOR_ID = B. LOCATOR_ID)
End of information on OTHER waiting sessions.
Current SQL statement for this session:
Update ana_seg
Set
SEGMENT_ID =: 1,
SEAT_STATUS =: 2,
SEGMENT_CLASS =: 3,
SEGMENT_SHARE_CLASS =: 4,
SEG_SEAT_NO =: 5,
SEG_CREATION_NUM =: 6,
SEG_CREATION_TIME =: 7
Where locator_id =: 8
And SEG_ORDER_ID =: 9