oracle sessionkill掉后连接未释放,需要OS层杀死的进程

select spid from gv$process where (inst_id,addr) in (
select inst_id,addr from gv$process where pid<>1 and pname is null
minus
select inst_id,paddr from gv$session)

posted on 2023-01-17 11:53  抡砖  阅读(43)  评论(0)    收藏  举报

导航