Slow Connections Time Under Heavy Load in Application using JDBC 11.2.0.3 and JDK 1.5 (Doc ID 2642217.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Slow connections/logons under heavy load in application using JDBC 11.2.0.3 and JDK 1.5.

An average time based on the logs are from 40 to 60 milliseconds, but times peak up to even 106694 milliseconds.

Thin driver connection time - 47 millisecond(s)
Thin driver connection time - 42 millisecond(s)
Thin driver connection time - 76 millisecond(s)
Thin driver connection time - 77 millisecond(s)
Thin driver connection time - 103902 millisecond(s)  ==>  HERE
Thin driver connection time - 98 millisecond(s)
Thin driver connection time - 117 millisecond(s)
Thin driver connection time - 105120 millisecond(s)  ==>  HERE
Thin driver connection time - 109 millisecond(s)
Thin driver connection time - 106694 millisecond(s)  ==> HERE
Thin driver connection time - 98 millisecond(s)
Thin driver connection time - 192 millisecond(s)
Thin driver connection time - 121 millisecond(s)
Thin driver connection time - 234 millisecond(s)
Thin driver connection time - 96 millisecond(s)
Thin driver connection time - 108673 millisecond(s)  ==> HERE

Connections are excepted to complete in the average time between 40 and 60 milliseconds.

Changes

Cause

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