以下锁怎么只有一个会话的信息？请教一下
*** 2016-05-11 09:24:01.710
*** SESSION ID
1158.28565) 2016-05-11 09:24:01.709
DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE CUX_LINE_SIGNBOARD SET FLOW_STATUS_CODE = :B13 , ITEM_NAME = :B12 , ITEM_DESC = :B11 , ITEM_SIZE = :B10 , QUANTITY = :
B9 , REQUISITION_NAME = :B8 , REQUISITION_GROUP = :B7 , REQUISITION_DATE = :B6 , REQUISITION_NOTE = :B5 , PROCESS_NOTE = NULL
, EMPLOYEE_GROUP = :B4 , PROCESS_DATE = NULL, PROCESS_NAME = NULL, EMPLOYEE_ID = :B3 , FORWARD_TO = NULL, FORWARD_TYPE = NULL
, FORWARD_NOTE = NULL, FORWARD_DATE = NULL, APPROVAL_NAME = NULL, APPROVAL_NOTE = NULL, ORG_ID = :B2 , LAST_UPDATED_BY = FND_
PROFILE.VALUE('USER_ID') WHERE LINE_ID = :B1
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
TX-00600020-00112bf4 3231158 X
3231158 X
session 1158: DID 0001-0143-0001095Dsession 1158: DID 0001-0143-0001095D
Rows waited on:
Session 1158: obj - rowid = 0016ABCA - AAFqvKABuAAAtaIAAU
(dictionary objn - 1485770, file - 110, block - 185992, slot - 20)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
===================================================
|
