Oracle 19c JMX JDBCDataSourceRuntime Metrics Missing

Products

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

Issue/Introduction

After the application upgraded their database to Oracle 19c and changed to the osjdb6 (11.2.0.4) driver, the JMX JDBCDataSourceRuntime metrics stopped reporting for the Oracle 19c db connection pool but continued to report for the Oracle 11g db connection pool.

 

Environment

Release : 10.7.0

Component : APM Agents

Cause

In the agent logs

[WARN] [IntroscopeAgent.Clamp] JMX metric clamp has been hit, no additional JMX metrics will be reported

 

Resolution

customer was hitting the clamp introscope.agent.jmx.clamp=500. He increased to 5000 and is now able to see the missing metrics.

IntroscopeAgent.profile

# Changing this property requires restarting the Monitored Process
introscope.agent.jmx.clamp=5000