alter system kill session doesnt kill session
Hi,
oracle:9.0.1.4
os: solaris
The user called me and said to kill the session since his session got hanged, he was using plsql navigator.
I tried to kill using the below
SQL> select sid,serial#,osuser,command from v$session where osuser='kumar';
SID SERIAL# OSUSER COMMAND
---------- ---------- ------------------------------ ----------
21 35299 kumar 0
22 58778 kumar 0
SQL> alter system kill session '21,35299';
System altered.
SQL> alter system kill session '22,58778' ;
System altered.
SQL> select sid,serial#,osuser,command from v$session where osuser='kumar';
SID SERIAL# OSUSER COMMAND
---------- ---------- ------------------------------ ----------
21 35299 kumar 0
22 58778 kumar 0
while executing the alter system kill session it says system altered but when i see it still shows me the user .
the user has to reboot his pc and got connected again .
now i can 3 sessions with the same username.
how to get rid of this problem.
ANY ideas.