Skip to Main Content

Deadlock

happy10319Dec 19 2019 — edited Dec 20 2019

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.

Comments
Post Details
Added on Dec 19 2019
5 comments
211 views