查看锁表进程SQL语句
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo, dba_objects ao, v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;
查看会话状态
select saddr, sid, serial#, paddr, username, status
from v$session t
where t.sid = '2587';
Oracle杀会话进程
ALTER SYSTEM KILL SESSION 'sid,serial#';
执行命令如果有ora-00031错误,则在后面加immediate;
ALTER SYSTEM KILL SESSION 'sid,serial#' immediate;
执行杀Oracle会话进程命令后,再次查询会话状态,如果会话仍然存在,且状态为killed。这时如果需要立即结束该进程并释放资源,需要进一步杀操作系统进程,可如下操作:
查询操作系统进程ID:PADDR
查询条件addr为查询会话状态中的paddr
select addr, pid, spid, username from v$process where addr ='0000000BC8BAB350';
根据sid生成操作系统杀进程命令查询
select 'kill -9 ' || p.spid
from v$session s, v$process p
where s.sid = sid
and p.ADDR = s.PADDR;
操作进程杀进程命令
在plsql的命令窗口或者Linux操作系统输入
kill -9 spid