oracle杀掉进程

1.先看一下数据库中那些表被锁住了。

    select b.owner,b.object_name,a.session_id,a.locked_mode  
    from v$locked_object a,dba_objects b  
    where b.object_id=a.object_id;  

2.查询引起锁定的回话，得到sid

    select b.username,b.sid,b.serial#,logon_time   
    from v$locked_object a,v$session b   
    where a.session_id = b.sid order by b.logon_time;  

3. 查出对应的SERIAL#

    select SID,SERIAL#,PADDR   
     FROM v$session   
     where SID='刚才查出的SID'  

4.杀死对应的死锁，在命令窗口中执行

alter system kill session'1025,41';其中1025为sid,41为serial#.