Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: UNIX question(killing a process)

Re: UNIX question(killing a process)

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Fri, 10 Nov 2000 08:29:48 -0600
Message-Id: <10676.121722@fatcity.com>

--------------2B220E09D728EB3E12435DCB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Three comments here:

1> Since Solaris has a bsd and system v version of PS, depending on which one you are pathed up for first, it would be helpful to know which one you are calling. (you can perform "which ps" to figure this out)

2> I hope, of course, you're not running MTS. :)

3> Ever hear of getting stuck latches from killing an Oracle process from the operating system? Using this technique, you will. :) You'd be better of killing them from the database (or better yet modify the client application to support a timeout connection feature)

--Roby

www.orageeks.com

Uma Sankara_Sivadanam wrote:

>
>
>      Hi,
>
>      Environment:SUNOS 5.6
>
>      I am working on a script which should check for processes using
>      ps and kill all the processs  which are IDLE for more than 15
>      minutes.
>
>      I need the exact syntax of the PS command(i mean the command
>      options).
>
>      cheers
>      /uma
>

--------------2B220E09D728EB3E12435DCB

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

Three comments here:
<p>1> Since Solaris has a bsd and system v version of PS, depending on
which one you are pathed up for first, it would be helpful to know which one you are calling. (you can perform "which ps" to figure this out)
<p>2> I hope, of course, you're not running MTS. :)
<p>3> Ever hear of getting stuck latches from killing an Oracle process
from the operating system? Using this technique, you will. :) You'd be better of killing them from the database (or better yet modify the client application to support a timeout connection feature)
<br>&nbsp;
<p>--Roby
<p>www.orageeks.com
<p>Uma Sankara_Sivadanam wrote:
<blockquote TYPE=CITE>&nbsp;
<ul><font face="Arial"><font color="#0000FF"><font size=-1>Hi,</font></font></font>
<p><font face="Arial"><font color="#0000FF"><font size=-1>Environment:SUNOS
5.6</font></font></font>
<p><font face="Arial"><font color="#0000FF"><font size=-1>I am working
on a script which should check for processes using</font></font></font><b>
<font face="Arial"><font color="#0000FF"><font size=-1>ps</font></font></font></b><font face="Arial"><font color="#0000FF"><font size=-1>
and kill all the processs&nbsp; which are IDLE for more than 15 minutes.</font></font></font>
<p><font face="Arial"><font color="#0000FF"><font size=-1>I need the exact
syntax of the PS command(i mean the command options).</font></font></font>
<p><font face="Arial"><font color="#0000FF"><font size=-1>cheers</font></font></font>
<br><font face="Arial"><font color="#0000FF"><font size=-1>/uma</font></font></font></ul>
Received on Fri Nov 10 2000 - 08:29:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US