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:user-b3f8dacb72c8@xymon.invalid]
Sent: Wednesday, March 06, 2013 07:50 PM
To: Andrey Chervonets <user-e7fb5c02322c@xymon.invalid>
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 <user-b3f8dacb72c8@xymon.invalid<mailto:user-b3f8dacb72c8@xymon.invalid>> 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 <user-e7fb5c02322c@xymon.invalid<mailto:user-e7fb5c02322c@xymon.invalid>> 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: +XXX XXXXXXXX<tel:%2B371%2026517848>
Fax: +XXX XXXXXXXX<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<user-b3f8dacb72c8@xymon.invalid<mailto:user-b3f8dacb72c8@xymon.invalid>>
To: Xymon mailinglist<xymon at xymon.com<mailto:xymon at xymon.com>>
Subject: [Xymon] New monitoring script on Xmonton
Message-ID:
<user-d01c4f3880d5@xymon.invalid<mailto:user-d01c4f3880d5@xymon.invalid>>
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
--
"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