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
12、oracle锁表查询spid进行杀掉
发布时间 2023-11-27 18:08:04作者: 站着说话不腰疼
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';
kill -9 SPID