Oracle关闭session锁

select session_id from v$locked_object;//找到锁的sessionId
 
SELECT * FROM v$session //查看该sessionId以及对应的serial
 
ALTER SYSTEM KILL SESSION '148,15001'; //根据sessionId和serial关闭
posted @ 2014-04-12 17:37  喵尾景虎  阅读(1717)  评论(0编辑  收藏  举报