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 Fax: +371 66066346
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> To: Xymon mailinglist<xymon at xymon.com> Subject: [Xymon] New monitoring script on Xmonton Message-ID: <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