1. ORACLE解锁
1.查找被锁定的表
select sess.sid,
where ao.object_id = lo.object_id and lo.session_id = sess.SID;
2.强制杀掉会话中锁定的进程
alter system kill session 'SID,SERIAL#';
1. ORACLE解锁
1.查找被锁定的表
select sess.sid,
where ao.object_id = lo.object_id and lo.session_id = sess.SID;
2.强制杀掉会话中锁定的进程
alter system kill session 'SID,SERIAL#';