alter system kill session doesnt kill session

[zakriyamhd]

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.

[marist89]

select sid,serial#,osuser,command,status
from v$session where osuser='kumar';

I suspect "status" will say KILLED.

[zakriyamhd]

yes it says killed,
so can we ignore this now also I can see the user in the v$session ?since the user told me he did not got any message that his session got killed or the application shud disconnect but he said he didnt got any such message.why so ?


SQL> select sid,serial#,osuser,command,status from v$session where osuser='kumar';

SID SERIAL# OSUSER COMMAND STATUS
---------- ---------- ------------------------------ ---------- --------
21 35299 kumar 0 KILLED
22 58778 kumar 0 KILLED

[topgun]

try using

alter system kill session '22,58778' immediate;


hope this helps...

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.

[bazza]

Try killing the process at the OS level. Get the OSPID and then do a kill -9 on it.

Bazza

[pando]

Depending what was he doing the operation is not immediate