oracle ??С?????????????sys???????????????SQL???
???????????? ???????[ 2016/9/14 10:03:24 ] ????????????? Oracle
?????Щ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
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11