Spring Application Generates High Parse Calls With Zero Executions When Using JDBC 12.2
(Doc ID 2695294.1)
Last updated on AUGUST 03, 2020
Applies to:JDBC - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
After switching an IBM WAS 8.5 application running on AIX 188.8.131.52 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 184.108.40.206 and 220.127.116.11 databases running on AIX 18.104.22.168.
Upgrade of JDBC driver from 11.2 to 12.2.
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