首页 > itarticle > oracle record is locked by another user 将所有的锁kill掉

oracle record is locked by another user 将所有的锁kill掉

admin 11月 12, 2020 0

今天连接一个远程oracle服务器操作的比较快但是网比较慢，结果在更新语句时提示 record is locked by another user,记录下解决办法。

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;

将所有的锁kill掉

alter system kill session 'sid,serial#'

环境 Oracle11G R2