[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] monitor processes by owner



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
>
>
>