[Xymon] New monitoring script on Xmonton - db_cpu.ksh

[Novosielski, Ryan]

Curious -- what platforms don't have top? I know that Solaris doesn't have it, but it still has prstat. Sorry for the off-topic stray.



From: Vernon Everett [mailto:everett.vernon at gmail.com]
Sent: Wednesday, March 06, 2013 07:50 PM
To: Andrey Chervonets <a.chervonets at cominder.eu>
Cc: xymon at xymon.com <xymon at xymon.com>
Subject: Re: [Xymon] New monitoring script on Xmonton - db_cpu.ksh

Hi all

I have updated this script to fix Andrey's reported bug.
I have also added an option to use sar for calculating %Idle, after Nick reminded me that top is not part of a standard install.

Regards
Vernon

On 2 March 2013 20:08, Vernon Everett <everett.vernon at gmail.com<mailto:everett.vernon at gmail.com>> wrote:
A good catch, and something I didn't consider.
All our databases instances have very different names, so the scenario you describe just never occurred to me.
I will have a look at fixing this one when I get back to the office on Tuesday. (Monday is a public holiday here)
However, if anybody wants to suggest a fix, or even update the code, go for it.

Regards
Vernon



On 2 March 2013 17:14, Andrey Chervonets <a.chervonets at cominder.eu<mailto:a.chervonets at cominder.eu>> wrote:
Good news.

Had reviewed the script. There may be one problem in that lines:
--
   for PROC in $(ps -efa | grep $DB | awk '{ print $2 }')
--
You do just grep, but imagine there may be instances like:
MYDB
MYDB1
MYDB12
or NOMYDB
So it will count MYDB numbers for MYDB1, MYDB12 and NOMYDB too

We should make grepping more intelligent, because oracle processes may be listed like:
 ora_j000_MYDB
oracleMYDB (LOCAL=NO)
 ora_ckpt_MYDB
and so on


Best regards,

Andrey Chervonets
----------------------
CoMinder Ltd.
http://www.cominder.eu/
Mobile: +371 26517848<tel:%2B371%2026517848>
Fax: +371 66066346<tel:%2B371%2066066346>



On 01.03.2013 13:00, xymon-request at xymon.com<mailto:xymon-request at xymon.com> wrote:
Message: 10
Date: Fri, 1 Mar 2013 14:40:58 +0800
From: Vernon Everett<everett.vernon at gmail.com<mailto:everett.vernon at gmail.com>>
To: Xymon mailinglist<xymon at xymon.com<mailto:xymon at xymon.com>>
Subject: [Xymon] New monitoring script on Xmonton
Message-ID:
        <CAGo4kcYUaYJ8TSjrs4xf7pNzptsB3vk3B5omLAae_M-2jtWokg at mail.gmail.com<mailto:CAGo4kcYUaYJ8TSjrs4xf7pNzptsB3vk3B5omLAae_M-2jtWokg at mail.gmail.com>>
Content-Type: text/plain; charset="iso-8859-1"

Hi all

I have just put something together to monitor Oracle database CPU usage.
http://www.xymonton.org/monitors:db_cpu.ksh

_______________________________________________
Xymon mailing list
Xymon at xymon.com<mailto:Xymon at xymon.com>
http://lists.xymon.com/mailman/listinfo/xymon



--
"Accept the challenges so that you can feel the exhilaration of victory"
- General George Patton



--
"Accept the challenges so that you can feel the exhilaration of victory"
- General George Patton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20130306/bf5686fd/attachment.html>