//查看所有的进程
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
//杀死某一个进程 sid和serial#根据上面的查询数据得来
alter system kill session 'sid,serial#';
转载于:https://my.oschina.net/u/2326864/blog/1532067
//查看所有的进程
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
//杀死某一个进程 sid和serial#根据上面的查询数据得来
alter system kill session 'sid,serial#';
转载于:https://my.oschina.net/u/2326864/blog/1532067