代码&优雅着&生活

导航

oracle死锁解决方法

select SESS.sid, SESS.SERIAL#, LO.ORACLE_USERNAME, LO.OS_USER_NAME,
      AO.OBJECT_NAME, LO.LOCKED_MODE
from V$LOCKED_OBJECT LO, DBA_OBJECTs AO, V$SESSION SESS
where AO.OBJECT_ID = LO.OBJECT_ID
and lo.session_id = sess.sid;


alter system kill session '135,9720';

posted on 2015-08-10 22:37  幸运的凌人  阅读(212)  评论(0编辑  收藏  举报