Inactive jdbc connection

[Sri]

Hi Erman,

what happens if we kill inactive session without any activity for last 2 days(will connection go back to pool or new connection gets created in the pool,what happens?)

As always thanks for your advices and support

[ErmanArslansOracleBlog]

If those inactive connections are coming from the connection pool, I don't recommend you to kill them.
This is expected behaviour. EBS uses database connection pool, so at any given point of time, there can be inactive database sessions.
Let connection pool to manage them.
Shrink, refresh, expand operations are done automatically by WebLogic Server based on settings for the connection pool.
"WLS knows about its connections. It tests them. If a connection fails the test, WLS closes and recreates the connection, and then tests the new connection."

[Sri]

Thanks erman for good inputs

will WLS does the shrink and testing connections automatically unless we specify in R12.2

[ErmanArslansOracleBlog]

Connection pool will manage its connection according to its configuration parameters.

[Sri]

Thanks erman

I agree,but we dont have shrink and test connection parameters set by default.Then how connection pool shrinks these connections

[ErmanArslansOracleBlog]

It is about weblogic.
Read ->https://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/domain_jdbcconnectionpool_config_connections.html

Then check your connection pool configuration to see if it will shrink it or not.

[Sri]

Erman,

Thanks for such a good doc.Without explicitily giving shrink,the connection pool will shrink the connections?in our case we didnt mention any shrink and test connection parameters in connection pool

Thank you

[ErmanArslansOracleBlog]

Sri,

Please read the document that I sent you.
Please concantrate on the parameters about shrinking..
 
For ex: Allow Shrinking, Shrink Frequency etc.
Read their definitions and try to understand.

Then check your connection parameter settings for those parameters.
See the value they are set and give your answer yourself.

[Sri]

Hi Erman,

we are on R12.2.5,we didnt set shrink parameter but yes the connections are shrinking

[ErmanArslansOracleBlog]

You didn't set but did you check if it is already set by default?

[Sri]

yes erman,i have checked it..it is not set by default.we are on r12.2.5

[ErmanArslansOracleBlog]

So what are you asking then?

Did you see the default values of those parameters in the following doc?
The values are by default "true", so it is as what you expected..

https://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/domain_jdbcconnectionpool_config_connections.html

for ex: Allow Shrinking = true (default)

[Sri]

Thanks erman