sqlstmmaxparamlength
Where does the value of sqlstmmaxparamlength come from?
Regards,
Anoh Brou
Good question - let me answer that with another question, where have you found or seen it?
A bit more info would be helpful, from the name I can only guess it has something to do with sql statements, parameters and a maximum length.
Best, Roman
sqlstmmaxparamlength is one of the metrics that can be chosen under CHART ->Add Series -> Create Measure -> Server Side Performance -> Agent Based Measures -> Custom JMX -> Custom JMX Measure -> Browse Metrics -> SqlStmMaxParamLength.
Regards,
Anoh Brou
JMX (short for Java Management Extensions) is a standard interface used by applications and app servers to provide metrics and operations related to the management of that app/app server. We can capture metrics from JMX through the Java agent (cyclic measure, every 10s).
So the question on what this metric means is best answered by looking at the documentation of the application server or app that you have seen it at. Googling for it I found no hits for the metric you listed above, only hits for SqlStmtMaxParamLength on Oracle connection pools.
Best, Roman
