获得当前锁表用户和杀死该用户进程

获得锁表用户:(查看session_id)就是该用户       

  select a.owner,
       a.object_name,
       a.subobject_name,
       a.object_type,
       l.session_id,
       l.oracle_username,
       l.os_user_name,
       se.SID,
       se.SERIAL#
  from  all_objects a, v$locked_object l,V$session se
where a.object_id = l.object_id
       and se.OSUSER = l.os_user_name
       and l.oracle_username = 'TEST';

 

新查法,只需要当前应用程序使用的用户名和被锁的sessionid与连到oracle的sessionid相同即可.

select sess.sid, sess.serial# from v$locked_object lo,
                                   v$session sess
                             where
                               lo.ORACLE_USERNAME = 'TEST'
                               and lo.session_id = sess.sid;

 

杀死该进程

alter system kill session 'SID,SERIAL#';