查锁表及kill

当一个表一直被锁住而无法进行操作的时候，可以用如下方法

 

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#;

模板：alter system kill session 'sid,serial#' immediate;
实例：alter system kill session '145,761' immediate;

转载于:https://www.cnblogs.com/tianmingt/p/4434764.html