(1) 找出吊死session
找出状态为inactive的session,如图:
select saddr,sid,serial#,paddr,username,status from v$session;
(2) 杀死session
使用session对应的 sid 和 serial# 将其杀死
alter system kill session ‘sid,serial#’ ;
alter system kill session '29,39';
alter system kill session '35,29';
会话终止:
select saddr,sid,serial#,paddr,username,status from v$session where username is not null;