查看哪些表被锁

select do.owner,do.object_name,lo.session_id,lo.locked_mode from v$locked_object lo, dba_objects do where do.object_id=lo.object_id;

查看被锁表的sid 和 serial#

select s.username,s.sid,s.serial#,s.logon_time from v$locked_object lo, v$session s where lo.session_id=s.sid order by s.logon_time;

表解锁

-- 其中 sid 和 serial#为上一步查询到的值
alter system kill session 'sid, serial#';