My Oracle Support Banner

Configuration of ODP4DRDA Client Timeouts (Doc ID 2536086.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database Provider for DRDA - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

We have the next configuration:
DB2 database server accessing Oracle Database server through ODP4DRDA. (DB2=>ODP4DRDA=>Oracle)
The response time of the query's that we launch from DB2 takes sometimes only a few milliseconds and sometimes hundreds of milliseconds.
We trace the Database sessions in the service of DRDA. We see that sometimes the ODP begins a new session and this times the query takes hundreds of seconds, but when the query reuses a open session it takes only a few seconds.

Example:
  Query1: it need to open a new connection, takes 400 ms.
  Query2: uses one open connection, takes 10 ms
  Query3: uses one open connection, takes 10 ms
  Query3: Use a new connection, takes 400 ms.

We don't find any parameter in ODP4DRDA that we can use to manage the disconnection time of the connections in ODP4DRDA.
Is there any way to maintain the connections opened to avoid reconnects?

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
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.