oracle解锁被锁住的行，表

执行sql

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;

 把查询出的参数 sid 与 serial# 放入下面sql执行

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;