dbms pmda

[Alan Hoyt <ahoyt@xxxxxxxxxxxxx>]

>Also from the http://oss.sgi.com/projects/pcp/contribute.html page:
>
>Agents for Oracle, Informix and Sybase (we have these for IRIX, but
>need someone with relevant DBMS expertise who might be willing
>to make them operational for Linux and help keep them working

Two Issues:

1) I have had some detailed discussions with Mark Boyd about per session 
metrics and name space management on large servers running multiple 
Oracle instances - there seems to be a diverging metrics acquisition 
philosophy emerging.

2) We need to get the Oracle and Sybase pmdas into PCP release 2.4.

Having access to the existing Oracle/Sybase pmda source code could help 
elucidate design tradeoff decisions that were made in the older releases 
and help expedite our efforts.

What we are proposing:

If SGI provides:
• Open Source versions of the existing Oracle and Sybase pmdas
• Any related Oracle/Sybase QA scripts (whenever the opportunity arises).

We will provide:
• Clean up existing source code - merge pmda code and resolve metric 
acquisition philosophies between pmdas (adding support for Oracle 8.1.7 
and 9.2 - i.e. a substantial update).
• Clean up non portable source dependencies (i.e. IRIX, Linux IA32, 
Solaris)
• Provide RPM and PKG build scripts
• Provide on-going maintenance and gatekeeper functions for Oracle and 
Sybase pmdas.

Note: Our pmda should support Oracle 9.2 on Linux IA64 (which is 
currently in beta) but this is not currently a priority.

As a result, the wider PCP community would benefit from having updated 
Oracle and Sybase pmdas - this would definitely help improve the value 
added prospect of PCP.


- Alan -