Rollback Segments metrics are not being reported for the databse when using the Oracle Database Monitoring extension for APMIA

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

Using the Oracle Database Monitoring extension for APMIA the Rollback Segments metrics are missing from the investigator tree

and the following error is reported in the log file

 

[ERROR] [IntroscopeAgent.DBMonitor]
com.jayway.jsonpath.PathNotFoundException: No results for path: $['resultSet'][0]['GETS']
        at com.jayway.jsonpath.internal.path.EvaluationContextImpl.getValue(EvaluationContextImpl.java:133)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:187)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:102)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:85)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:488)
        at com.ca.agent.extensions.dbmon.helper.DBMonJsonPathHelper.evaluate(DBMonJsonPathHelper.java:76)
        at com.ca.agent.extensions.dbmon.commands.DBMonPopulateAPMMetricsCommand                                  .appendValuesToSingleMetric(DBMonPopulateAPMMetricsCommand.java:118)
        at com.ca.agent.extensions.dbmon.commands.DBMonPopulateAPMMetricsCommand                                  .generateAPMMetric(DBMonPopulateAPMMetricsCommand.java:109)
        at com.ca.agent.extensions.dbmon.commands.DBMonPopulateAPMMetricsCommand.execute(DBMonPopulateAPMMetricsCommand.java:89)
        at com.ca.agent.extensions.dbmon.DBMonChain.run(DBMonChain.java:66)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

Environment

Release : 20.2

Component : APM Agents

Cause

The extension issues the following query to extract the Rollback Segment metrics

SELECT sum(gets) as GETS,sum(waits) as WAITS,sum(waits)/sum(gets)*100 as RATIO_WAIT_GET FROM V$ROLLSTAT;

 

the output should be similar to the following

 

     GETS      WAITS RATIO_WAIT_GET
---------- ---------- --------------
    786592         91     .011568895

 

In this case the SQL returned only null values when executed as the user account defined in the extension configuration

Resolution

Customer worked with Oracle DBA to address why the v$rollstat view was not being populated in Oracle