先通过select sid,serial#,status from v$session where owner='youerown'找到
sid,serial#.
status应该为inactive,
然后
alter system kill session 'sid,serial#';
这样就可以终止该进程了!!
sid,serial#.
status应该为inactive,
然后
alter system kill session 'sid,serial#';
这样就可以终止该进程了!!
v$session
v$process
select sid,serial#,username from v$session where username='yourname';
select pid,spid,username from v$process;
如上杀掉就可以了