查詢死鎖
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
梓楓 閱讀(429)
評論(0) 編輯 收藏 所屬分類:
oracle