oracle解锁被锁住的行，表

使用下面查询语句查询： sid 与 serial#

SELECT

   c.owner,c.object_name,c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine

FROM

   v$locked_object a ,all_objects c ,v$session b

WHERE

   b.sid = a.session_id AND a.object_id = c.object_id;

查询到后使用：
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE; 语句将被锁住的表解锁即可