查询表死锁情况及处理的语句[@more@]
查询锁死表的进程的SQL语句:
select a.SESSION_ID,
c.SERIAL#,
a.OBJECT_ID,
a.ORACLE_USERNAME,
a.OS_USER_NAME,
b.object_name
from v$locked_object a, dba_objects b, v$session c
where a.OBJECT_Id = b.object_id
and a.SESSION_ID = c.SID
然后利用alter system kill session 'sid,serial#'杀掉死锁此表的进程
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/532823/viewspace-911437/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/532823/viewspace-911437/