Oracle查询锁定记录及删除会话。解决update操作失败、超时等情况

Oracle查询锁定记录及删除会话。解决update操作 失败、超时等情况

--锁表（阻塞）原因
SELECT   l.session_id sid,
		 s.serial#,
		 l.locked_mode,
		 l.oracle_username,
		 s.user#,
		 l.os_user_name,
		 s.machine,
		 s.terminal,
		 s.status,
		 a.sql_text,
		 a.action,
		 s.logon_time
FROM v$sqlarea a, v$session s, v$locked_object l
WHERE l.session_id = s.sid
		AND s.prev_sql_addr = a.address
ORDER BY  s.logon_time;

删除指定会话

-- sid,serial#替换为查询出来的对应字段
ALTER system KILL session 'sid,serial#';

字段含义