2020
11-06
11-06
oracle锁表该如何解决
废话不多说上语句：查询锁表语句：selectobject_name,machine,s.sid,s.serial#fromv$locked_objectl,dba_objectso,v$sessionswherel.object_id=o.object_idandl.session_id=s.sid;杀掉查到的进程：altersystemkillsession'sid,serial#';例如：altersystemkillsession'20,182';如果杀不掉可以加个immediate 立即杀掉试试；altersystemkillsession'20,182'immediate;如果利用上面的命令杀死...
继续阅读 >