ORACLE解锁语句

1、查询锁住的session_id

select session_id from v$locked_object;

假设查出 441
2、根据session_id（441）查出具体信息
SELECT sid, serial#, username, osuser FROM v$session where sid = 441;

假设查询结果为：441    3463    CMS4_IMP     lusen
3、解锁
ALTER SYSTEM KILL SESSION '441,3463';

转载于:https://www.cnblogs.com/senlu/p/9273807.html