杀掉 oracle 中 lock table

杀掉 oracle 中 lock table

 

1. 查看哪些

select s.username, s.osuser, s.sid, s.serial#, p.spid
  from v$session s,v$process p
 where s.paddr = p.addr and s.username='ERPTION'
   and s.username is not null

 

2.查看这个运行的sql

select sql_text
from v$session a,v$sqltext_with_newlines b
where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value
and a.sid = 657

alter system kill session '1100,6440';

 

---

3.在根据sid 查到os中的spid
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=657

 

4.在 根据这个spid 到linux 中 kill 如下：
kill - 9 19163