12、oracle锁表查询spid进行杀掉

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