Oracle kill session – 删除被死锁的会话

select a.owner,

       a.object_name,

       b.xidusn,

       b.xidslot,

       b.xidsqn,

       b.session_id,

       b.oracle_username,

       b.os_user_name,

       b.process,

       b.locked_mode,

       c.machine,

       c.status,

       c.server,

       c.sid,

       c.serial#,

       c.program

  from all_objects a, v$locked_object b, sys.gv_$session c

 where (a.object_id = b.object_id)

   and (b.process = c.process);

 

 

kill it：

1

alter system kill session 'sid, serial#'

比如

1

alter system kill session '12, 53673' 

 

know the numeric value for different locks. 
0,'None', 
1,'Null (NULL)' 
2,'Row-S (SS)' 
3,'Row-X (SX)' 
4,'Share (S)' 
5,'S/Row-X (SSX)' 
6,'Exclusive (X)'