Database Tuning (MOSC)

MOSC Banner

TM lock

edited Aug 18, 2016 5:00AM in Database Tuning (MOSC) 7 commentsAnswered

Hi ,

We have table sales and purchase  and both are accessing block 2 with LMOD=3.  there is no reference meaning sales has primary key but no constraint in purchase.

Now how we can resolve this locking issue?

SQL> Select SID,TYPE,ID1,ID2,LMODE,REQUEST,CTIME,BLOCK  from v$lock where block >0 and SID=745;

       SID TY        ID1        ID2      LMODE    REQUEST      CTIME      BLOCK

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

       727 AE        100          0          4          0        133          2

       727 JS     406416          3          6          0        133          2

       727 TM     188003          0          3          0        133          2

       727 TM     188004          0          3          0        133          2

       727 TM     198195          0          3          0        133          2

       727 TM     198196          0          3          0        133          2

       727 TM     188005          0          3          0        128          2

       727 TM     188006          0          3          0        123          2

       727 TM     188007          0          3          0        119          2

       727 TM     188008          0          3          0        114          2

       727 TM     188009          0          3          0        110          2

       SID TY        ID1        ID2      LMODE    REQUEST      CTIME      BLOCK

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

       727 TM     188010          0          3          0        105          2

       727 TM     188011          0          3          0         99          2

       727 TM     188012          0          3          0         95          2

       727 TM     188013          0          3          0         91          2

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