Spring Application Generates High Parse Calls With Zero Executions When Using JDBC 12.2
(Doc ID 2695294.1)
Last updated on AUGUST 30, 2023
Applies to:
JDBC - Version 12.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After switching an IBM WAS 8.5 application running on AIX 7.1.0.0 to use 12.2 ojdbc8.jar instead of 11.2 ojdbc6.jar, an extraordinary number of parses with no executions are seen in AWR. For example:
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
805,628 0 90.62 <sql id> JDBC Thin Client <sql statement>
The issue affects performance. When reverting back to 11.2 ojdbc6.jar, the high parse statement goes away.
The issue is observed against 11.2.0.4 and 12.2.0.1 databases running on AIX 7.1.0.0.
Changes
Upgrade of JDBC driver from 11.2 to 12.2.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |