工作笔记

2019独角兽企业重金招聘Python工程师标准>>>

Oracle锁表

查找被锁的表

select l.session_id,o.owner,o.object_name
from v$locked_object l,dba_objects o
where l.object_id=o.object_id;

查找引发锁表的会话

select s.username,s.sid,s.serial#,s.logon_time
from  v$locked_object l,v$session s
where l.session_id=s.sid 
order by s.logon_time;

Kill对应的进程

alter system kill session '115,7355';

转载于:https://my.oschina.net/u/1033181/blog/2988683