How to configure the PowerPack for Oracle to report new metrics?
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">