Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: UNIX question(killing a process)
--------------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
<!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>
<p>--Roby
<p>www.orageeks.com
<p>Uma Sankara_Sivadanam wrote:
<blockquote TYPE=CITE>
<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 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