Oracle 解锁Record is locked by another user?
Oracle 解锁Record is locked by another user?

在操作ORACLE数据库的时候，由于执行完，没有COMMIT，直接把PL/SQL关闭掉，后来导致那张表被锁住，当编辑时就会出现这个信息，record is locked by another user！
当出现这种情况的时候，只要操作下面几个步骤就可以解锁了。

1.查看被锁住的表：外部邮件发件箱表OA_NET_MAIL_FJXSELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID   FROM ALL_OBJECTS A, V$LOCKED_OBJECT V WHERE A.OBJECT_ID = V.OBJECT_ID    AND A.OBJECT_NAME LIKE 'OA_NET_MAIL_FJX';2.查看锁：select t2.username,t2.sid,t2.serial#,t2.logon_time  from v$locked_object t1,v$session t2  where t1.session_id=t2.sid order by t2.logon_time; 3.根据session_id(SID) kill掉这个session：alter system kill session 'sid,serial#' ：alter system kill session '26,53109';4.查看表大小：