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

Products

• APP PERF MANAGEMENT
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CUSTOMER EXPERIENCE MANAGER
• INTROSCOPE

Issue/Introduction

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

Environment

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

Resolution

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