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

Document ID : KB000016653
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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

Answer:

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:

CASupportTEST_NEWPPOracleMetric.jpg