 Unable to kill a session using Orakill [message #567219] |
Tue, 25 September 2012 07:09  |
|
|
Dear All,
Please note today i faced one issue i unable to kill one database session,Today i killed one session
alter system kill session '418,12499'
but status shows as killed but process still exits in OSLevel
SQL> select sid,serial#,status from gv$session where sid=418;
SID SERIAL# STATUS
---------- ---------- --------
418 12499 KILLED
we all know we can kill by using ORAKIL but still we unable to kill
SQL> select spid from v$process a, v$session b where a.addr = b.paddr and b.sid = '418';
SPID
------------
5644
i killed using orakill
C:\Documents and Settings\Administrator>orakill oraci 5644
Kill of thread id 5644 in instance oraci successfully signalled.
but still process exits in os level also i notice below error in alert log
orakill: ssthreadkill(tid=5644) unable to get the thread list mutex: err=0
please advice on above error.
Thanks&Regards,
Anil
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
