Hi,
On 11.2.0.4
When deadlock, we have the following in trc file:
How to interprete this information and which action should be done to resolve?
I see the same session (905) is at the same time blocker and waiter. Can be explained please?
Which object is locked? How can we unlock it?
Thanks.
*** 2019-12-15 15:08:28.002
*** SESSION ID:(1233.1531) 2019-12-15 15:08:28.002
*** CLIENT ID:(RSA:240025847196) 2019-12-15 15:08:28.002
*** SERVICE NAME:(sid) 2019-12-15 15:08:28.002
*** MODULE NAME:(XX/APEX:DUU 111:131) 2019-12-15 15:08:28.002
*** ACTION NAME:(Processes - point: BEFORE_BOX_BODY) 2019-12-15 15:08:28.002
*** 2019-12-15 15:08:28.002
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
TX-00350006-00064247 348 1233 X 441 905 X
TX-002b000a-000ed507 441 905 X 348 1233 X
session 1233: DID 0001-015C-00000174 session 905: DID 0001-01B9-00000356
session 905: DID 0001-01B9-00000356 session 1233: DID 0001-015C-00000174
Regards.