??????????????????????
????????????е?????У??????????水??????????????????г???????

?????????????????
?????????????????????????????????????????????????????????
???????????????????????????????2????????????е?????????????
????????????????????????????У??????????г???????б????

???????????????λ????
?????????????????????????????????????????????????????????????
????1????dba?????????????
????select username??lockwait??status??machine??program from v$session where sid in
????(select session_id from v$locked_object)
???????????????????????????????????????????????????????????????
????Username????????????????????????
????Lockwait???????????????????????????????
????Status?? ????active?????????
????Machine?? ?????????????????
????Program?? ?????????????????????????ó???
????2????dba???????????????????????????????
????select sql_text from v$sql where hash_value in
????(select sql_hash_value from v$session where sid in
????(select session_id from v$locked_object))

???????????????????
???????????￡???????????????????????????????????????й????С??????
????????????????????????????????????????????????????????
??????????Oracle????ù?????????????????????????????????????
????1??????????????????
????sqlplus "/as sysdba" (sys/change_on_install)
????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;
????2??kill???????????????
????alter system kill session ‘sid??serial#’; ??????sid=l.session_id??
????3???????????????
????select pro.spid from v$session ses??v$process pro where ses.sid=XX and ses.paddr=pro.addr;
????????sid????????sid?滻: exit
????ps -ef|grep spid
????????spid???????????????kill?????Oracle????
????from:http://southking.javaeye.com/blog/550832
????select A.SQL_TEXT?? B.USERNAME?? C.OBJECT_ID?? C.SESSION_ID??
????B.SERIAL#?? C.ORACLE_USERNAME??C.OS_USER_NAME??C.Process??
????''''||C.Session_ID||'??'||B.SERIAL#||''''
????from v$sql A?? v$session B?? v$locked_object C
????where A.HASH_VALUE = B.SQL_HASH_VALUE and
????B.SID = C.Session_ID