-
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.
People with goals know where they are going
-
Code:
select sid,serial#,osuser,command,status
from v$session where osuser='kumar';
I suspect "status" will say KILLED.
Jeff Hunter
-
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
People with goals know where they are going
-
try using
alter system kill session '22,58778' immediate;
hope this helps...
Originally Posted by 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.
-
Try killing the process at the OS level. Get the OSPID and then do a kill -9 on it.
Bazza
-
Depending what was he doing the operation is not immediate
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|