TM lock
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