问题描述
oracle数据库中,有时候会话已经被kill了,状态已经是killed了,但是会话在v$session中长时间不结束,怎么办?
oracle 10g处理方法
使用下面的sql查询spid
SELECT addr,pid,spid,username,serial#,terminal,program
FROM V$PROCESS
WHERE
PROGRAM NOT IN ('PSEUDO')
AND ADDR NOT IN (SELECT PADDR FROM V$BGPROCESS)
AND ADDR NOT IN (SELECT PADDR FROM V$SESSION)
AND ADDR NOT IN (SELECT PADDR FROM V$SHARED_SERVER)
AND ADDR NOT IN (SELECT PADDR FROM V$DISPATCHER)
知道spid后,在操作系统杀死进程,kill -9 spid
oracle11g处理方法
使用下面的sql查询spid
select * from v$process where addr in (select Creator_addr from v$session where status='killed');
知道spid后,在操作系统杀死进程,kill -9 spid
原文链接:https://blog.csdn.net/weixin_43230594/article/details/131688382