Oracle解决锁表问题

解决思路：

先查到被锁表对应的session_id和SERIAL#，通过session_id和SERIAL#解锁表

简单2步：

步骤1：查看被锁表，获取session_id，SERIAL#

select a.session_id,c.SERIAL#,a.locked_mode, b.owner,b.object_name
From v$locked_object a,dba_objects b,v$session c  
Where b.object_id = a.object_id and c.sid = a.SESSION_ID;

步骤2：解锁

  alter system kill session 'session_id,serial#'