?????ЩORACLE?е????????????????"killed"?????????????????????????????????????????????????????????????????????????????ORACLE???????????OS????????
????1.?????????????????Щ????????
????select object_name??machine??s.sid??s.serial#
????from v$locked_object l??dba_objects o ??v$session s
????where l.object_id??=??o.object_id and l.session_id=s.sid;
????2.???????????????????????
????alter system kill session '24??111'; (????24??111???????????????sid??serial#)
??????????????????????????Oracle?????????????С?
????3.??????????????????????????????????????"killed"???????????????????????б??????????????os???????????????????????????????????????y???????????
????select spid?? osuser?? s.program
????from v$session s??v$process p
????where s.paddr=p.addr and s.sid=24 ??24???????sid??
????4.??OS???????????????????
????1)??unix?????root??????????:
????#kill -9 12345??????3?????????spid??
????2)??windows??unix????????orakill???????orakill??oracle?????????????????????
????orakill sid thread
???????У?
????sid????????????????????????
????thread??????????????????3?????????spid??
????????c:>orakill orcl 12345