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.