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> 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
Fax: +XXX XXXXXXXX
On 01.03.2013 13:00, 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<user-b3f8dacb72c8@xymon.invalid>
To: Xymon mailinglist<xymon at xymon.com>
Subject: [Xymon] New monitoring script on Xmonton
Message-ID:
<CAGo4kcYUaYJ8TSjrs4xf7pNzptsB**3vk3B5omLAae_M-2jtWokg at mail.**
gmail.com<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<http://www.xymonton.org/monitors:db_cpu.ksh>;
______________________________**
Xymon at xymon.com<
--
"Accept the challenges so that you can feel the exhilaration of victory"
- General George Patton