查询死锁
SELECT s.username,
l.OBJECT_ID,
l.SESSION_ID,
s.SERIAL#,
l.ORACLE_USERNAME,
l.OS_USER_NAME,
l.PROCESS
FROM V$LOCKED_OBJECT l, V$SESSION S
WHERE l.SESSION_ID = S.SID
alter system kill session '239,63272'
posted on 2010-05-26 10:52
梓枫 阅读(419)
评论(0) 编辑 收藏 所属分类:
oracle