oracle锁表处理

查询sid

SELECT l.session_id sid,
s.serial#,
l.locked_mode ,
l.oracle_username ,
l.os_user_name ,
s.machine ,
s.terminal ,
o.object_name ,
s.logon_time  FROM v$locked_object l, all_objects o, v$session s WHERE l.object_id = o.object_id
AND l.session_id = s.sid ORDER BY sid, s.serial#;

查询spid

//393为sid
select s.sid, s.serial#, s.LOGON_TIME, s.machine, p.spid, p.terminal
from v$session s, v$process p
 where s.paddr = p.addr
 and s.sid = 393; --   

oracle安装目录下执行
orakill路径如下: oracle安装目录\product\12.2.0\dbhome_1\bin

//3368为spid
orakill MES 3368