search cancel

How to configure the PowerPack for Oracle to report new metrics?


Article ID: 16653


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE


How to configure the PowerPack for Oracle to report new metrics?


Release: CEMUGD00200-9.7-Introscope to CA Application-Performance Management-Upgrade Main


The OrclSqlMetricMappings.conf configuration file contains the metrics definitions of the Powerpack for Oracle database, this file is available inside of the <PP_HOME>\lib\PPOracleDB.jar

Please note that any customization to OrclSqlMetricMappings.conf is not supported by CA Support, the below enhancement request has been submitted to the APM Product Management team:

DE318545 - Make OrclSqlMetricMappings.conf available and supported so the powerpack can be easily customized and extended. 

The below simple example illustrate how to create a new metric, a duplication of "OracleAgent | <hostname> | <SID> | version" named: "version2"

1. Stop the Powerpack for Oracle service

2. Open the <PP_HOME>\lib\PPOracleDB.jar using 7zip, edit the OrclSqlMetricMappings.conf 

3. Locate the line:

Version;SELECT version FROM V$INSTANCE;StringEvent 

Duplicate the line and update the first word as it represents the metric name:

Version2;SELECT version FROM V$INSTANCE;StringEvent 

4. Save the file

5. Start the Powerpack for Oracle service

Here is the result of this change in the investigator:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKhyAAG" alt="CASupportTEST_NEWPPOracleMetric.jpg" width="1152" height="721">


1558717195481000016653_sktwi1f5rjvs16uh5.jpeg get_app