Oracle 解锁Record is locked by another user

Oracle 解锁Record is locked by another user?Oracle 解锁Record is locked by another user? 在操作ORAC

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.查看表大小: