方法一:
1、select sid, serial# from v$session
where username = '用户名 ' and
status = 'INACTIVE';
2、alter system kill session 'sid,serial#';
方法二、linux下kill spid
查找spid方法:
1、select sid,serial#,paddr from v$session
where username = 'QIANZU_NEW' and
status = 'INACTIVE';
2、select * from v$process
where addr = '步骤1中paddr ';
3、kill spid
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12272958/viewspace-678251/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12272958/viewspace-678251/