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

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

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>