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

[Nathan Scott <nathans@xxxxxxxxxx>]

----- Original Message -----
> Hi,
> 
> On 2016-05-19 15:39, Ken McDonell wrote:
> > On 19/05/16 19:38, Marko Myllynen wrote:
> >> ...
> > 
> > Just a reminder, two-threaded PMDAs (one for PMCD, one for SQL) and
> > PM_ERR_PMDANOTREADY were invented in the first place to accommodate slow
> > DBMS PMDAs.

(Twas introduced for slow startup originally though, IIRC, is that right?
In Markos case, several queries seem to be permanently slow).

> Thanks for pointing that out - Nathan, does this sound at all feasible
> /helpful for the Oracle PMDA?

Its something we might use, but its operating mainly under the assumption
that slowness is transient and its all about getting an error to the client
when the database is slow to respond (while the PMDA keeps going, instead
of timing out).  In the case of the system here, we'll get lots of instances
of that error code & not so much useful values.

cheers.

--
Nathan