How to kill process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to kill process

  1. #1
    Join Date
    Aug 2001
    Posts
    14
    Hi
    how can I kill process when the process is > Max Process ?

    thanks always!

  2. #2
    More info require...

    Do you want to check for idle process? Sniped process? ???

  3. #3
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    if process is > Max process, he won't even exist ...

  4. #4

    Wink Oracle Information

    I read this document, and it helped me! So have a read it might help you :-)

    Doc ID: Note:96170.1
    Subject: Script for killing sniped sessions shadow processes
    Type: PROBLEM
    Status: PUBLISHED
    Content Type: TEXT/PLAIN
    Creation Date: 17-JAN-2000
    Last Revision Date: 18-APR-2000


    Problem Description
    -------------------

    If "init.ora" resource_limit = true, and idle_time set in profile.

    When idle_time exceeds, the session status becomes 'sniped' in v$session,
    but sniped sessions never get cleaned up.

    Using 'alter system kill session' to kill the session, session status becomes
    'killed' in v$session, but still is never cleaned up.


    Solution Description
    --------------------

    On Unix, and if using a dedicated server, use the following shell script to
    kill the shadow process (script has been tested on Solaris, AIX, Tru64 and
    HPUX):

    #!/bin/sh
    tmpfile=/tmp/tmp.$$
    sqlplus system/manager < spool $tmpfile
    select p.spid from v\$process p,v\$session s
    where s.paddr=p.addr
    and s.status='SNIPED';
    EOF
    for x in `cat $tmpfile | grep "^[0123456789]"`
    do
    kill -9 $x
    done
    rm $tmpfile


    Explanation
    -----------

    According to several bugs as shown in references, it's still expected behaviour
    that sniped session may never clean up. The only workaround is to kill the
    shadow process.


    References
    ----------

    [BUG:697369], [BUG:617545]


  5. #5
    Join Date
    Aug 2001
    Posts
    14

    Where can I find this DOC?

    Originally posted by birdax1
    I read this document, and it helped me! So have a read it might help you :-)

    Doc ID: Note:96170.1
    Subject: Script for killing sniped sessions shadow processes
    Type: PROBLEM
    Status: PUBLISHED
    Content Type: TEXT/PLAIN
    Creation Date: 17-JAN-2000
    Last Revision Date: 18-APR-2000


    Problem Description
    -------------------

    If "init.ora" resource_limit = true, and idle_time set in profile.

    When idle_time exceeds, the session status becomes 'sniped' in v$session,
    but sniped sessions never get cleaned up.

    Using 'alter system kill session' to kill the session, session status becomes
    'killed' in v$session, but still is never cleaned up.


    Solution Description
    --------------------

    On Unix, and if using a dedicated server, use the following shell script to
    kill the shadow process (script has been tested on Solaris, AIX, Tru64 and
    HPUX):

    #!/bin/sh
    tmpfile=/tmp/tmp.$$
    sqlplus system/manager < spool $tmpfile
    select p.spid from v\$process p,v\$session s
    where s.paddr=p.addr
    and s.status='SNIPED';
    EOF
    for x in `cat $tmpfile | grep "^[0123456789]"`
    do
    kill -9 $x
    done
    rm $tmpfile


    Explanation
    -----------

    According to several bugs as shown in references, it's still expected behaviour
    that sniped session may never clean up. The only workaround is to kill the
    shadow process.


    References
    ----------

    [BUG:697369], [BUG:617545]


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