-- 查出被所对象的session_id
select session_id from v$locked_object;
-- 71是上一句中查出的ID
SELECT sid, serial#, username, osuser FROM v$session where sid = 71;
-- 删除session_id 其中71,17234是上一句中的sid, serial#值
ALTER SYSTEM KILL SESSION '71,17234';
select session_id from v$locked_object;
-- 71是上一句中查出的ID
SELECT sid, serial#, username, osuser FROM v$session where sid = 71;
-- 删除session_id 其中71,17234是上一句中的sid, serial#值
ALTER SYSTEM KILL SESSION '71,17234';