查询
--- 查询某个表TABLE_NAME锁定 ---
SELECT s.sid, s.serial#, o.object_name, s.machine
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
AND o.object_name = 'TABLE_NAME';
--- 解锁 alter system kill session's.sid,s.serial#';---
alter system kill session'39,9504';