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

[Marko Myllynen <myllynen@xxxxxxxxxx>]

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.

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

FWIW, I checked how long the Oracle AWR report generation takes, it's
around 10 seconds which the local DBAs consider "normal." So perhaps we
can't expect the same approach which works with local /proc files to
work as-is with a massive Oracle instance under extreme load but rather
come up with something else, perhaps like Ken suggested above?

Thanks,

-- 
Marko Myllynen