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<user-b3f8dacb72c8@xymon.invalid>
To: Xymon mailinglist<xymon at xymon.com>
Subject: [Xymon] New monitoring script on Xmonton
Message-ID:
<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