Oracle执行SQL锁行如何解决？

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;