查看被锁的表:
WHERE l.object_id = o.object_id AND l.session_id = s.sid;
1.解锁,输入sid和serial#
--alter system kill session 'sid, serial#';
ALTER system kill session '23, 1647';
2.出现 ora-00031 标记要终止的会话。
3.用sid 查找spid
select spid, osuser, s.program from v$session s, v$process p
where s.paddr = p.addr and s.sid =1713;
4.登录unix kill掉spid 进程。