ORACLE执行update或insert挂死不动
查出锁死的session
select object_name, machine, s.sid, s.serial#
from v$locked_object l, dba_objects o, v$session s
where l.object_id = o.object_id
and l.session_id = s.sid;
杀掉
alter system kill session '296,60544';
原创
2020-07-23 22:18:54 ·
449 阅读 ·
0 评论