My Oracle Support Banner

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 and later
Information in this document applies to any platform.


After switching an IBM WAS 8.5 application running on AIX 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  and databases running on AIX


 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.