我在客户端执行了"select * from abc for update"后,没有执行"commit",表被系统锁定,不能更新.因为客户端用户只分配了"查询,更新"权限,其他权限都没有.请问服务端不作任何处理,系统能否自动解锁呢?如果能解,一般在多长时间后解锁呢?谢谢!
width="728" height="90" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" id="aswift_2" name="aswift_2" style="box-sizing: content-box; left: 0px; position: absolute; top: 0px;">
-
-
-
id="iframeu1636201_0" src="http://pos.baidu.com/kcnm?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=2&ps=742x506&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1464136846536&ti=oracle%E9%94%81%E8%A1%A8%E5%90%8E%2C%E7%B3%BB%E7%BB%9F%E8%83%BD%E5%90%A6%E8%87%AA%E5%8A%A8%E8%A7%A3%E9%94%81%3F(%E6%80%A5)-CSDN%E8%AE%BA%E5%9D%9B-CSDN.NET-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&ari=1&dbv=2&drs=3&pcs=1082x574&pss=1082x5822&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1464136846<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F200006235<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DhqFh7KQs_ezVygIc_zBtpOM666bWyQu8PMQbR7t8rauYoNPfMf9APJz1RpXuHn1a%26wd%3D%26eqid%3D93d4232c000a4bd2000000055744f472&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1464136847&qn=18c55dfcc36495bf&tt=1464136846512.33.242.245" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
-
id="iframeu1636204_0" src="http://pos.baidu.com/kcnm?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=3&ps=742x760&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1464136846536&ti=oracle%E9%94%81%E8%A1%A8%E5%90%8E%2C%E7%B3%BB%E7%BB%9F%E8%83%BD%E5%90%A6%E8%87%AA%E5%8A%A8%E8%A7%A3%E9%94%81%3F(%E6%80%A5)-CSDN%E8%AE%BA%E5%9D%9B-CSDN.NET-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&ari=1&dbv=2&drs=3&pcs=1082x574&pss=1082x5822&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1464136846<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F200006235<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DhqFh7KQs_ezVygIc_zBtpOM666bWyQu8PMQbR7t8rauYoNPfMf9APJz1RpXuHn1a%26wd%3D%26eqid%3D93d4232c000a4bd2000000055744f472&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1464136847&qn=7ba063a0a7bfe22c&tt=1464136846512.35.257.257" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">