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)
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)