[Xymon] New monitoring script on Xmonton - db_cpu.ksh

[Vernon Everett]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20130307/55858757/attachment.html>