Sessions are Reconnected After 10 Minutes

Document ID : KB000103815
Last Modified Date : 19/07/2018
Show Technical Document Details
According the following documentation, sessions should remain active indefinitely (maxIdleTime = 0 and maxConnectionAge = 0) and they should test connectivity every 10 minutes with the following request "select 1 from dual" (preferredTestQuery) to check if BD is alive. 

Currently, we see that all the sessions are reconnected in 10 minutes (600 seconds). 

We also checked the link : 
And this link : 
We normally recommend that our customers set their JDBC connection configurations to look like the following:

User-added image

NOTE: For each thread in the pool size, the Gateway will use 8MB of RAM to hold this connection - so for the example 8X15=120MB