Database Tuning (MOSC)

MOSC Banner

11.2.0.1 : enq: TX - row lock contention issue in database

edited May 26, 2014 12:00PM in Database Tuning (MOSC) 2 commentsAnswered

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 contention13,590359005990.89

Application

On investigation , found the following situation

BLOCKING_SESSION   SIDSERIAL#

---------------- ---------- ----------

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%';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center