1、查询锁进程的信息
SELECT a.spid, b.sid, b.serial#, b.username, b.sql_id ,c.SQL_TEXT
FROM v$process a, v$session b,v$sql c
WHERE a.addr = b.paddr
AND c.sql_id = b.sql_id
AND b.status = 'KILLED'
AND b.sql_id IS NOT NULL;
2、kill锁
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;