pcp
[Top] [All Lists]

Re: Oracle connection debugging (was Re: [pcp] Handling Oracle PMDA Late

To: Marko Myllynen <myllynen@xxxxxxxxxx>
Subject: Re: Oracle connection debugging (was Re: [pcp] Handling Oracle PMDA Latencies)
From: Nathan Scott <nathans@xxxxxxxxxx>
Date: Fri, 27 May 2016 00:16:19 -0400 (EDT)
Cc: pcp developers <pcp@xxxxxxxxxxx>
Delivered-to: pcp@xxxxxxxxxxx
In-reply-to: <5746BC6F.9030400@xxxxxxxxxx>
References: <56F25541.9020602@xxxxxxxxxx> <573D897A.5070804@xxxxxxxxxx> <626822210.48972762.1463726815586.JavaMail.zimbra@xxxxxxxxxx> <573EDF38.1020102@xxxxxxxxxx> <594283644.49214956.1463982724891.JavaMail.zimbra@xxxxxxxxxx> <5742C49E.4090208@xxxxxxxxxx> <142091188.49924255.1464248230746.JavaMail.zimbra@xxxxxxxxxx> <5746BC6F.9030400@xxxxxxxxxx>
Reply-to: Nathan Scott <nathans@xxxxxxxxxx>
Thread-index: nvKA90HAHf3csnbXvs5v+XPLZGECZA==
Thread-topic: Oracle connection debugging (was Re: [pcp] Handling Oracle PMDA Latencies)
Hi Marko,

----- Original Message -----
> On 2016-05-26 10:37, Nathan Scott wrote:
> > ----- Original Message -----
> >> [...]
> >> so I can't see how to improve this. Thus your suggestion to make these
> >> two clusters opt-in is probably the most feasible solution at least in
> >> the short-term. Here oracle.object_cache will be ignored but I can try
> >> to see how things work after enabling oracle.file.
> > 
> > My main QA machine is in the late stages of dying unfortunately, so I've
> > not finished QA on this change yet - but, here's a pmdaoracle.pl patch to
> > try out in the meantime.  (see $disable_object_cache & $disable_filestat)
> 
> Thank you very much - now after disabling object cache in the configuration
> file ./Install works as expected and "time pminfo -f oracle > /dev/null"
> reports time between 2.7-3.6s under medium load.
> 

OK, good to know - and alot of that time is the v$filestat query I suppose.

> Below is a trivial patch to keep connect.pl in sync (all the variables
> need to be defined before eval) and tidy up reporting a bit.

Merged.

> With these two patches I think we're in decent shape here.

Glad to hear it!

> PS. I noticed this in QA 023, looks like a typo?
> 
>         -e '/cmd=\/usr\/pcp\/lib\/pmdaoracle7/d' \

Heh, that's actually a leftover from the original pmdaoracle from IRIX (which
was written in C, using pro*C).  I've cleaned that up now.

cheers.

--
Nathan

<Prev in Thread] Current Thread [Next in Thread>