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> 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> 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 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<everett.vernon at gmail.com>
To: Xymon mailinglist<xymon at xymon.com> Subject: [Xymon] New monitoring script on Xmonton Message-ID: <CAGo4kcYUaYJ8TSjrs4xf7pNzptsB**3vk3B5omLAae_M-2jtWokg at mail.** gmail.com<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<http://www.xymonton.org/monitors:db_cpu.ksh>
______________________________**_________________ Xymon mailing list Xymon at xymon.com http://lists.xymon.com/**mailman/listinfo/xymon<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