monitor processes by owner
list Josie Wells
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
list Jerald Sheets
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 * user-dc7b196c5161@xymon.invalid * XXX.XXX.XXXX *XXX.XXX.XXXX
▸
-----Original Message-----
From: Josie Wells [mailto:user-94bf861d423d@xymon.invalid]
Sent: Thursday, October 29, 2009 6:40 AM
To: user-ae9b8668bcde@xymon.invalid
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
list David Lee
I'm new to the list myself but why are you monitoring oracle processes? Won't it be more straight forward to query v$session for the corresponding processes? I'm playing around with dbcheck (within http://sourceforge.net/projects/hobbit-perl-cl/) and it does that. I "believe" it can generate a graph showing the spikes in # of oracle sessions. If it doesn't, you should be able to write a shell script listing all the oracle jobs, count and then graph it. Right now, I'm pulling hairs out of my head trying to adapt dbcheck to my environment. ;0 David
▸
On Thu, Oct 29, 2009 at 6:39 AM, Josie Wells <user-94bf861d423d@xymon.invalid> wrote:
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
list Patrick Nixon
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
▸
<user-dc7b196c5161@xymon.invalid> 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 * user-dc7b196c5161@xymon.invalid * XXX.XXX.XXXX *XXX.XXX.XXXX -----Original Message----- From: Josie Wells [mailto:user-94bf861d423d@xymon.invalid] Sent: Thursday, October 29, 2009 6:40 AM To: user-ae9b8668bcde@xymon.invalid 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
list Bruce White
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: XXX-XXX-XXXX | Fax: XXX-XXX-XXXX | user-58f975e8bf9d@xymon.invalid | 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:user-1f2406f832af@xymon.invalid] Sent: Thursday, October 29, 2009 11:58 AM
To: user-ae9b8668bcde@xymon.invalid
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 <user-dc7b196c5161@xymon.invalid> 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 * user-dc7b196c5161@xymon.invalid * XXX.XXX.XXXX *XXX.XXX.XXXX -----Original Message----- From: Josie Wells [mailto:user-94bf861d423d@xymon.invalid] Sent: Thursday, October 29, 2009 6:40 AM To: user-ae9b8668bcde@xymon.invalid 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
list Josie Wells
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 <user-58f975e8bf9d@xymon.invalid> wrote:
From: White, Bruce <user-58f975e8bf9d@xymon.invalid> Subject: RE: [hobbit] monitor processes by owner To: user-ae9b8668bcde@xymon.invalid 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: XXX-XXX-XXXX | Fax: XXX-XXX-XXXX | user-58f975e8bf9d@xymon.invalid | 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:user-1f2406f832af@xymon.invalid] Sent: Thursday, October 29, 2009 11:58 AM To: user-ae9b8668bcde@xymon.invalid 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 <user-dc7b196c5161@xymon.invalid> 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 aPROC, it would be acustom check. Jerald Sheets Sr. Systems Engineer CNN News Systems * user-dc7b196c5161@xymon.invalid * XXX.XXX.XXXX *XXX.XXX.XXXX -----Original Message----- From: Josie Wells [mailto:user-94bf861d423d@xymon.invalid] Sent: Thursday, October 29, 2009 6:40 AM To: user-ae9b8668bcde@xymon.invalid 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
list Greg Hubbard
More ideas: 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") 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. 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. GLH
▸
On Mon, Nov 2, 2009 at 8:53 AM, Josie Wells <user-94bf861d423d@xymon.invalid> wrote:
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 <user-58f975e8bf9d@xymon.invalid> wrote:From: White, Bruce <user-58f975e8bf9d@xymon.invalid> Subject: RE: [hobbit] monitor processes by owner To: user-ae9b8668bcde@xymon.invalid 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: XXX-XXX-XXXX | Fax: XXX-XXX-XXXX | user-58f975e8bf9d@xymon.invalid | 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:user-1f2406f832af@xymon.invalid] Sent: Thursday, October 29, 2009 11:58 AM To: user-ae9b8668bcde@xymon.invalid 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 < user-dc7b196c5161@xymon.invalid> 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 aPROC, it would be acustom check. Jerald Sheets Sr. Systems Engineer CNN News Systems * user-dc7b196c5161@xymon.invalid * XXX.XXX.XXXX *XXX.XXX.XXXX -----Original Message----- From: Josie Wells [mailto:user-94bf861d423d@xymon.invalid] Sent: Thursday, October 29, 2009 6:40 AM To: user-ae9b8668bcde@xymon.invalid 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
--
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.