not able to kill session

Posted on 2012-04-09
Medium Priority
Last Modified: 2012-04-26
I am not able to kill a session.

SQL>  ALTER SYSTEM KILL SESSION '889, 46821'  immediate;

System altered.


Question by:dba1234
  • 2
LVL 38

Assisted Solution

by:Gerwin Jansen, EE MVE
Gerwin Jansen, EE MVE earned 500 total points
ID: 37824902
As what user are you trying this? When you try to kill the session as the same user that owns the session, it should work.
LVL 18

Accepted Solution

sventhan earned 500 total points
ID: 37824942
It takes some time. Try killing it from unix

kill -9 processid
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 1000 total points
ID: 37824949
author, you might have got confused with the sid..

oracle allocates SID(Service Identifiers) dynamically, it doesn't mean that you just have killed a SID and it should not appear again..

yes, for some time, the SID,Serial# combination will not appear

check with sid and serial#

you should use your query like this

SELECT STATUS FROM V$SESSION WHERE SID='889' and serial#='46821'  

then you can actually see whether the process got killed or not..

to be more precise, you can check the paddr from the v$session before killing the session like this

select paddr V$SESSION WHERE SID='889'  and place this value in

select * from v$process where addr='<pddr from above query>' to get the OS process id,where in you can check the status at Operating System level too..!!!
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 1000 total points
ID: 37824958
its possible that the sid which you have just killed might have got allocated with some other process, so you are seeing it again.. as mentioned in my earlier comment check the sid and serial# combination..

and be careful while seeing alone the SID it will lead to killing of some unwanted process which may lead to some other problems..

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question