在修改数据后,比如 删除一条数据
提交后出现这个画面,原因是什么?如何解决?
------解决思路----------------------
感觉是另一个会话,锁住了部分记录。
------解决思路----------------------
死锁,当前表格被其它会话占用
------解决思路----------------------
SELECT distinct
l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, s.user#,
l.os_user_name,s.machine, s.terminal,a.sql_text, a.action
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 sid, s.SERIAL#
alter system kill session'SELECT distinct
l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, s.user#,
l.os_user_name,s.machine, s.terminal,a.sql_text, a.action
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 sid, s.SERIAL#
--查出来sid,serial后干掉即可
alter system kill session'sid,serial';