topic Re: locks in Data Management Questions https://community.esri.com/t5/data-management-questions/locks/m-p/32345#M1769 <HTML><HEAD></HEAD><BODY><P>I observed one more thing.</P><P>SELECT * FROM sde.table_locks;</P><P></P><TABLE height="77" style="width: 375px; height: 79px;" width="373"><TBODY><TR><TD>214</TD><TD>267</TD><TD>S</TD><TD>05-02-16</TD></TR><TR><TD>218</TD><TD>246</TD><TD>S</TD><TD>05-02-16</TD></TR></TBODY></TABLE><P></P><P>The application is not able to release above mentioned locks</P></BODY></HTML> Mon, 02 May 2016 10:51:38 GMT jayasudha 2016-05-02T10:51:38Z locks https://community.esri.com/t5/data-management-questions/locks/m-p/32344#M1768 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>We have bulk DML process that uses ArcSDE 11.1.</P><P>I observed dba_lock view in oracle 11gR2 regularly for the following.</P><P></P><P>select * from dba_lock where session_id=226;</P><P></P><P>sid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lock_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mode_held&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; last_convert</P><TABLE height="109" style="width: 765px; height: 111px;" width="763"><TBODY><TR><TD>226</TD><TD>AE</TD><TD>Share</TD><TD>None</TD><TD>100</TD><TD>0</TD><TD>4355</TD><TD>Not Blocking</TD></TR><TR><TD>226</TD><TD>PL/SQL User Lock</TD><TD>Exclusive</TD><TD>None</TD><TD>1073742268</TD><TD>0</TD><TD>4354</TD><TD>Not Blocking</TD></TR><TR><TD>226</TD><TD>TO</TD><TD>Row-X (SX)</TD><TD>None</TD><TD>68064</TD><TD>1</TD><TD>4218</TD><TD>Not Blocking</TD></TR></TBODY></TABLE><P></P><P>Various locks are applied and released regularly and after some time, the locks do not change except the LAST_CONVERT value keep on increasing. Then the process hangs.</P><P></P><P>The log switch activity is at every 15 min.</P><P></P><P>Please inform your suggestion</P></BODY></HTML> Mon, 02 May 2016 06:14:37 GMT https://community.esri.com/t5/data-management-questions/locks/m-p/32344#M1768 jayasudha 2016-05-02T06:14:37Z Re: locks https://community.esri.com/t5/data-management-questions/locks/m-p/32345#M1769 <HTML><HEAD></HEAD><BODY><P>I observed one more thing.</P><P>SELECT * FROM sde.table_locks;</P><P></P><TABLE height="77" style="width: 375px; height: 79px;" width="373"><TBODY><TR><TD>214</TD><TD>267</TD><TD>S</TD><TD>05-02-16</TD></TR><TR><TD>218</TD><TD>246</TD><TD>S</TD><TD>05-02-16</TD></TR></TBODY></TABLE><P></P><P>The application is not able to release above mentioned locks</P></BODY></HTML> Mon, 02 May 2016 10:51:38 GMT https://community.esri.com/t5/data-management-questions/locks/m-p/32345#M1769 jayasudha 2016-05-02T10:51:38Z