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 12.2.0.0.0 and later
Information 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


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