Oracle锁表处理代码

报错现象：忘记截图了，这里只能拿张网图了）

查询锁表记录

SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects b, v$session s
WHERE l.session_id = s.sid AND l.object_id = b.object_id;

解除锁表

ALTER SYSTEM KILL SESSION 'sid,serial#';

示例

ALTER SYSTEM KILL SESSION '642,5139';