11.2.0.1 : enq: TX - row lock contention issue in database
Hi,
We are running EBS R12.1.3 on 11.2.0.1 . We suddenly have this issue in environment. There is a concurrent request which is running for more than 6 hours. On investigation , i found the following
From AWR report
enq: TX - row lock contention | 1 | 3,590 | 3590059 | 90.89 | Application |
On investigation , found the following situation
BLOCKING_SESSION | SID | SERIAL# |
---------------- ---------- ----------
WAIT_CLASS | SECONDS_IN_WAIT |
---------------------------------------------------------------- ---------------
240 | 353 | 5640 |
Application
select SID,TYPE,ID1,ID2,LMODE,REQUEST from v$lock where type='TX';
SID TY ID1 ID2 LMODE REQUEST
---------- -- ---------- ---------- ---------- ----------
353 TX 3407894 47703 0 6
353 TX 1179667 4754409 6 0
select sid,p1raw, p2, p3,event from v$session_wait where wait_time=0 and event like '%enq%';