oracle锁表查询spid进行杀掉
1、查询
SELECT A.SPID, B.SID, B.SERIAL#, B.USERNAME
FROM V$PROCESS A, V$SESSION B
WHERE A.ADDR = B.PADDR
AND B.STATUS = 'KILLED';
2、linux Os执行杀掉进程
kill -9 SPID