Generating the SQLText Metric in DMS
1002441Apr 11 2013 — edited Oct 15 2014
I want the SQLText value to be set in JDBC DMS, from the document here http://docs.oracle.com/cd/B28359_01/java.111/b31224/dmsmtrc.htm#CHDBDDHB, it says:
If the 11.1 version of the DMS JAR file is present in the classpath environment variable, then JDBC checks the DMS update SQL text flag. If this flag is true, then the SQLText metric is updated.
If the 11.1 version of the DMS JAR file is not present in the classpath environment variable, then JDBC uses the value of the DMSStatementMetrics connection property. If this statement property is true, then SQLText metric is updated. The default value of this connection property is false.
The problems are that:
1) It does not mention how to set this "DMS update SQL text" flag.
2) What's the exact name of DMSStatementMetrics property, I can find the "oracle.jdbc.DMSStatementMetrics" from http://docs.oracle.com/cd/B14099_19/core.1012/b14001/optj2ee.htm#CACFHAHF, is it the right one?
Anyone can help me?