[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [hobbit] monitor processes by owner
- To: hobbit (at) hswn.dk
- Subject: Re: [hobbit] monitor processes by owner
- From: David Lee <palann (at) gmail.com>
- Date: Thu, 29 Oct 2009 12:23:48 -0400
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=pu49F7bpkU4RHpB+ZS38CwgB34CY7ECxxtaoxHVSBtk=; b=Sby02Ugb10CZ7VxamFASa1Okg91tBnQ0rfFkh1XGonDQsKKpw68k9Y1DtaUo8NB/TB bOBrdak6QE/v6FaZB73aZIpUCP1BWj+qX5XKnu0dyNGWWpy2zalu2Kt5QVAQiy8Eb3Gr TbX6rW4lN0YJ8bK/Br+RNYl0oloR0klQVeDlE=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=dL3WQlis6z6jE+80o5gm9/GL6pjVuUAhszY9laGNdDweMb6fMpW+unTxcc9NVbbZEw hsPXNZv0mvFCL0DVVVILJOTC9fETozZ7zHID8dQOIrZfqU/L3QYwWTY+pEslt/1OnMId e6ifpVXN7eHTc4gibsIW039iEfaRSuv1PPa2o=
- References: <967115.28307.qm (at) web55106.mail.re4.yahoo.com>
I'm new to the list myself but why are you monitoring oracle processes?
Won't it be more straight forward to query v$session for the corresponding
processes? I'm playing around with dbcheck (within
http://sourceforge.net/projects/hobbit-perl-cl/) and it does that. I
"believe" it can generate a graph showing the spikes in # of oracle
sessions. If it doesn't, you should be able to write a shell script listing
all the oracle jobs, count and then graph it.
Right now, I'm pulling hairs out of my head trying to adapt dbcheck to my
environment. ;0
David
On Thu, Oct 29, 2009 at 6:39 AM, Josie Wells <josie_wells (at) yahoo.com> wrote:
> Hi,
>
> I am new to this mailing list so apologies if I am breaking any protocol by
> sending this mail out to this address - I have searched the faqs and can
> find no answer.
>
> What I am trying to do is to monitor processes by the owner.
>
> In hobbit-clients.cfg I can specify a string to search for in the process
> name but I can find no way to look in the USER column.
>
> If I could, then I could get a count of processes owned by oracle and graph
> it out.
>
> Is this possible?
>
> Many thanks
>
> Josie
>
>
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe (at) hswn.dk
>
>
>