alter system kill session doesnt kill session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: alter system kill session doesnt kill session

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Code:
    select sid,serial#,osuser,command,status
    from v$session where osuser='kumar';
    I suspect "status" will say KILLED.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    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

  4. #4
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    try using

    alter system kill session '22,58778' immediate;


    hope this helps...

    Quote 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.

  5. #5
    Join Date
    Jul 2002
    Posts
    335
    Try killing the process at the OS level. Get the OSPID and then do a kill -9 on it.

    Bazza

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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
  •  



Click Here to Expand Forum to Full Width