oracle锁表

查询被锁的会话ID(session_id)
select * from v$locked_object;


查询会话详细信息
SELECT sid, serial#, username, osuser FROM v$session where sid = 2432;

会话关闭
ALTER SYSTEM KILL SESSION '2432,89';