Infrastructure agent Oracle DB extension metric resolution doesn't match property setting

Products

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

Issue/Introduction

The Oracle extension running within Infrastructure agent appears to only report metrics very 30 seconds, though it has the default configuration parameter introscope.agent.dbmonitor.oracle.queryInterval=15 in bundle.properties - see screen shot below.  Am I correct to think this is only reporting a value for every other 15 second interval?  If so, is it possible to get value every 15 seconds as I think graph with this sort of saw tooth pattern will confuse.  

 

Environment

Release : 20.2

Component : APM Agents

Cause

The configuration parameter introscope.agent.dbmonitor.oracle.queryInterval specifies the interval form the end of one database metric collection cycle and the start of the next. Thus if there is latency between the agent and the database or the DB queries take an extended time to execute then it is possible that the query will not take place during a particular interval. Even when the agent is local to the database this can occur

 

Resolution

To ensure metrics are collected at least once per 15 second interval reduce the value of the setting of the property introscope.agent.dbmonitor.oracle.queryInterval in the bundle.properties file for the oracle DB extension e.g. 

 

introscope.agent.dbmonitor.oracle.queryInterval=5

 

However if there is higher latency then it may be that this does not ensure data is collected every 15s interval