<div>More ideas:</div>
<div> </div>
<div>You can track (and graph) the number of processes that pass a regular expression. This is defined in hobbit-clients.cfg. This will show you how a count changes over time. This is similar to Patrick's idea, but perhaps more universal. (example: "PROC oracle TRACK=Oracle")</div>
<div> </div>
<div>You can define the process check for alerting and set the maximum number to a value that is near your max count -- this will alert you when you are in the "danger zone". Combine with above by adding count values (e.g. "1 32") to the command.</div>
<div> </div>
<div>Bruce's idea is good, too. There is no reason why you cannot use them all at the same time -- if only to help you validate your assumptions.<br></div>
<div>GLH<br></div>
<div class="gmail_quote">On Mon, Nov 2, 2009 at 8:53 AM, Josie Wells <span dir="ltr"><<a href="mailto:josie_wells@yahoo.com">josie_wells@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Thank you Bruce, Patrick, Jerald and David for your suggestions.<br><br>Although Patrick's idea sounds good I would like to monitor other processes as well if possible.<br>
<br>To confirm the the reasoning behind what I am trying to do, I am trying to see if the number of oracle owned processes ever comes close to the limit defined by the OS (MAXUPROC I think it's called) - a problem we have had in the past.<br>
<br>Therefore I'd like it to include all oracle processes rather than monitoring the oracle port as Bruce suggests.<br><br>Maybe the custom script is the way to go - but I'd really like to avoid that if I can.<br>
<br>Josie<br><br><br><br>--- On Mon, 11/2/09, White, Bruce <<a href="mailto:bewhite@fellowes.com">bewhite@fellowes.com</a>> wrote:<br><br>> From: White, Bruce <<a href="mailto:bewhite@fellowes.com">bewhite@fellowes.com</a>><br>
> Subject: RE: [hobbit] monitor processes by owner<br>> To: <a href="mailto:hobbit@hswn.dk">hobbit@hswn.dk</a><br>> Date: Monday, November 2, 2009, 3:26 PM<br>
<div>
<div></div>
<div class="h5">> I track and graph Oracle DB<br>> connections and connections to our Oracle forms server not<br>> via processes but by port connections. This is easily<br>> done under the ports test, without any changes to<br>
> code. In your hobbit-clients.cfg file, add a PORT rule<br>> which defines the port used to make the connection and a<br>> TRACK option.<br>><br>> .....Bruce<br>> <br>><br>><br>> <br>> Bruce White<br>
> Senior Enterprise Systems Engineer | Phone: 630-671-5169 |<br>> Fax: 630-893-1648 | <a href="mailto:bewhite@fellowes.com">bewhite@fellowes.com</a><br>> | <a href="http://www.fellowes.com/" target="_blank">http://www.fellowes.com/</a><br>
> <br>> <br>> <br>> Disclaimer: The information contained in this message may<br>> be privileged and confidential and protected from<br>> disclosure. If the reader of this message is not the<br>> intended recipient or an employee or agent responsible for<br>
> delivering this message to the intended recipient, you are<br>> hereby notified that any dissemination, distribution or<br>> copying of this communication is strictly prohibited. If you<br>> have received this communication in error, please notify us<br>
> immediately by replying to the message and deleting it from<br>> your computer. Thank you. Fellowes, Inc.<br>> <br>> -----Original Message-----<br>> From: Patrick Nixon [mailto:<a href="mailto:pnixon@gmail.com">pnixon@gmail.com</a>]<br>
><br>> Sent: Thursday, October 29, 2009 11:58 AM<br>> To: <a href="mailto:hobbit@hswn.dk">hobbit@hswn.dk</a><br>> Subject: Re: [hobbit] monitor processes by owner<br>><br>> Sort of similar to Jerald's idea, but it'll get you the<br>
> graphs easier. :)<br>><br>> On your db server, go into the client's etc directory and<br>> modify the hobbitclient.cfg.<br>><br>> changing<br>> PS="ps ax"<br>> to<br>> PS="ps ax | $GREP oracle"<br>
><br>> Caveat: This will restrict you to *JUST* monitoring<br>> processes for oracle, nothing else on the server in<br>> question.<br>><br>> On Thu, Oct 29, 2009 at 10:02 AM, Sheets, Jerald <<a href="mailto:Jerald.Sheets@turner.com">Jerald.Sheets@turner.com</a>><br>
> wrote:<br>> > How about write a custom script that is green when<br>> your ps -ef |grep<br>> > <procname> has the appropriate user, yellow if<br>> say, 1 or two is owned<br>> > by someone else, and maybe red if 5 or more?<br>
> ><br>> > You could also do no middle ground, too. Green<br>> or red.<br>> ><br>> > Fairly trivial, but it would not be monitored as a<br>> PROC, it would be a<br>> > custom check.<br>
> ><br>> > Jerald Sheets<br>> > Sr. Systems Engineer<br>> > CNN News Systems<br>> > * <a href="mailto:Jerald.Sheets@turner.com">Jerald.Sheets@turner.com</a><br>> > * 404.878.0566 *404.293.8762<br>
> ><br>> ><br>> ><br>> ><br>> ><br>> > -----Original Message-----<br>> > From: Josie Wells [mailto:<a href="mailto:josie_wells@yahoo.com">josie_wells@yahoo.com</a>]<br>> > Sent: Thursday, October 29, 2009 6:40 AM<br>
> > To: <a href="mailto:hobbit@hswn.dk">hobbit@hswn.dk</a><br>> > Subject: [hobbit] monitor processes by owner<br>> ><br>> > Hi,<br>> ><br>> > I am new to this mailing list so apologies if I am<br>
> breaking any<br>> > protocol by sending this mail out to this address - I<br>> have searched<br>> > the faqs and can find no answer.<br>> ><br>> > What I am trying to do is to monitor processes by the<br>
> owner.<br>> ><br>> > In hobbit-clients.cfg I can specify a string to search<br>> for in the<br>> > process name but I can find no way to look in the USER<br>> column.<br>> ><br>> > If I could, then I could get a count of processes<br>
> owned by oracle and<br>> > graph it out.<br>> ><br>> > Is this possible?<br>> ><br>> > Many thanks<br>> ><br>> > Josie<br>> ><br>> ><br>> ><br>> ><br>
> > To unsubscribe from the hobbit list, send an e-mail to<br>><br>> > <a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br>> ><br>> ><br>> ><br>> > To unsubscribe from the hobbit list, send an e-mail to<br>
><br>> > <a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br>> ><br>> ><br>> ><br>><br>> To unsubscribe from the hobbit list, send an e-mail to <a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br>
><br>><br>><br>> To unsubscribe from the hobbit list, send an e-mail to<br>> <a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br>><br>><br>><br><br><br><br><br><br>To unsubscribe from the hobbit list, send an e-mail to<br>
<a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br><br><br></div></div></blockquote></div><br><br clear="all"><br>-- <br>Disclaimer: 1) all opinions are my own, 2) I may be completely wrong, 3) my advice is worth at least as much as what you are paying for it, or your money cheerfully refunded.<br>