不知道为什么: 偶尝试了一下: C:\>orakill 12 972Could not attach to Oracle instance 12: err = 2C:\>orakill 11 5Could not attach to Oracle instance 11: err = 2C:\>orakill 12Usage: orakill sid thread where sid = the Oracle instance to target thread = the thread id of the thread to kill The thread id should be retrieved from the spid column of a query such as: select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr不过用alter system杀会话也很管用的: select sid,SERIAL#,username,status from v$session;alter system kill session '12,972' ; 系统已更改。另外的会话中: SQL> select * from cat; select * from cat * ERROR 位于第 1 行: ORA-00028: 您的会话己被删去
我也知道用ALTER SYSTEM KILL SESSION 这个能杀,不过有的时候这个杀完之后SESSION标记为KILLED但是并没有终止,所以有人告诉我用ORAKILL杀,结果就是这样了
SQL> alter system kill session '15235'; alter system kill session '15235' * ERROR 位于第 1 行: ORA-00026: missing or invalid session IDorakill不能用,我连这个都不能用,哈哈,咋回事
偶尝试了一下:
C:\>orakill 12 972Could not attach to Oracle instance 12: err = 2C:\>orakill 11 5Could not attach to Oracle instance 11: err = 2C:\>orakill 12Usage: orakill sid thread where sid = the Oracle instance to target
thread = the thread id of the thread to kill The thread id should be retrieved from the spid column of a query such as: select spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr不过用alter system杀会话也很管用的:
select sid,SERIAL#,username,status from v$session;alter system kill session '12,972' ;
系统已更改。另外的会话中:
SQL> select * from cat;
select * from cat
*
ERROR 位于第 1 行:
ORA-00028: 您的会话己被删去
alter system kill session '15235'
*
ERROR 位于第 1 行:
ORA-00026: missing or invalid session IDorakill不能用,我连这个都不能用,哈哈,咋回事
写错了。第一个参数应该是正个数据库的SID。而不是那个线程的SID这个应该怪ORACLE。弄得重名。ORAKILL ORAINSTANCE,740这样就可以。