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 <user-94bf861d423d@xymon.invalid> 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