查看表锁和解除表锁
–查询锁表信息解除表锁
--查看锁表信息
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;
--查看锁后,找出sid,serial#,将所有的锁kill掉
ALTER system kill session 'sid,serial#';
示例:
--查看锁后,找出sid,serial#,将所有的锁kill掉
ALTER system kill session '146, 20273';