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">