Thank you Bruce, Patrick, Jerald and David for your suggestions.
Although Patrick's idea sounds good I would like to monitor other processes as well if possible.
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.
Therefore I'd like it to include all oracle processes rather than monitoring the oracle port as Bruce suggests.
Maybe the custom script is the way to go - but I'd really like to avoid that if I can.
Josie
--- On Mon, 11/2/09, White, Bruce <bewhite at fellowes.com> wrote:
From: White, Bruce <bewhite at fellowes.com> Subject: RE: [hobbit] monitor processes by owner To: hobbit at hswn.dk Date: Monday, November 2, 2009, 3:26 PM I track and graph Oracle DB connections and connections to our Oracle forms server not via processes but by port connections. This is easily done under the ports test, without any changes to code. In your hobbit-clients.cfg file, add a PORT rule which defines the port used to make the connection and a TRACK option.
.....Bruce
Bruce White Senior Enterprise Systems Engineer | Phone: 630-671-5169 | Fax: 630-893-1648 | bewhite at fellowes.com | http://www.fellowes.com/ Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Fellowes, Inc. -----Original Message----- From: Patrick Nixon [mailto:pnixon at gmail.com]
Sent: Thursday, October 29, 2009 11:58 AM To: hobbit at hswn.dk Subject: Re: [hobbit] monitor processes by owner
Sort of similar to Jerald's idea, but it'll get you the graphs easier. :)
On your db server, go into the client's etc directory and modify the hobbitclient.cfg.
changing PS="ps ax" to PS="ps ax | $GREP oracle"
Caveat: This will restrict you to *JUST* monitoring processes for oracle, nothing else on the server in question.
On Thu, Oct 29, 2009 at 10:02 AM, Sheets, Jerald <Jerald.Sheets at turner.com> wrote:
How about write a custom script that is green when your ps -ef |grep <procname> has the appropriate user, yellow if say, 1 or two is owned by someone else, and maybe red if 5 or more?
You could also do no middle ground, too. Green or red.
Fairly trivial, but it would not be monitored as a PROC, it would be a custom check.
Jerald Sheets Sr. Systems Engineer CNN News Systems
- Jerald.Sheets at turner.com
- 404.878.0566 *404.293.8762
-----Original Message----- From: Josie Wells [mailto:josie_wells at yahoo.com] Sent: Thursday, October 29, 2009 6:40 AM To: hobbit at hswn.dk Subject: [hobbit] monitor processes by owner
Hi,
I am new to this mailing list so apologies if I am breaking any protocol by sending this mail out to this address - I have searched the faqs and can find no answer.
What I am trying to do is to monitor processes by the owner.
In hobbit-clients.cfg I can specify a string to search for in the process name but I can find no way to look in the USER column.
If I could, then I could get a count of processes owned by oracle and graph it out.
Is this possible?
Many thanks
Josie
To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk
To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk