查询oracle锁表语句

MAVEN

mvn clean install -Dmaven.test.skip=true -U -X

--mvn编译
mvn clean install -Dmaven.test.skip=true -U -X


--设置vm
-mx2048m -XX:MaxPermSize=2048m -Drebel.spring_plugin=true -Drebel.hibernate_plugin=true


--查询oracle锁表语句
SELECT object_name, machine, s.sid, s.serial# 
FROM gv$locked_object l, dba_objects o, gv$session s 
WHERE l.object_id　= o.object_id 
AND l.session_id = s.sid; 
--释放SESSION SQL: 
--alter system kill session 'sid, serial#'; 
ALTER system kill session '23, 1647';