杀掉锁表进程

-------查询锁表的所有进程

select a.OS_USER_NAME, c.owner, c.object_name, b.sid, b.serial#, logon_time

from v$locked_object a, v$session b, dba_objects c

where a.session_id = b.sid

and a.object_id = c.object_id

order by b.logon_time;

 

-------杀掉单个的进程 sid,serial#

alter system kill session '210,11562';

 

-------杀掉所有的进程

declare cursor mycur is

select b.sid,b.serial#

　　from v$locked_object a,v$session b

　　where a.session_id = b.sid group by b.sid,b.serial#;

 

begin

for cur in mycur

loop

execute immediate ( 'alter system kill session '''||cur.sid || ','|| cur.SERIAL# ||''' ');

end loop;

end;

 

-------手动杀进程：点击Oracle 的菜单栏“工具-会话”，查看进程列，右键点击关闭，可以杀掉进程。