Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, Deepa.

Asked: May 25, 2023 - 7:27 am UTC

Last updated: May 29, 2023 - 3:46 am UTC

Version: 19c

Viewed 1000+ times

You Asked

I am facing issue of "Pooled connection request timed out" when I upgraded database to 19c and moved the application to cloud(TAS) from VM.
There is no fixed scenario when this happens. No code changes has been done except replacing DataAccess.dll to ManagedDataAccess.dll. SGA is set to 2GB. TAS memory is 2GB. Could you suggest me what configurations has to be setup or checked to support pooling, as I am developer and can delegate the same to DBA to have such configurations on database

and Connor said...

"Pooled connection request timed out" most commonly means you *do* have pooled connections, but you do not have any entries left in the pool to connect to.

Things to check

- connection storm (if your pool is 10, and 11 people all come in at once)
- insufficient pool size
- failure in connection disposal (you grab a connection, you *think* you're now done with, but the driver still thinks you're using it and thus wont release the connection back to the pool).
- long running transactions.

Turn on some tracing and check your ODP logs.

Is this answer out of date? If it is, please let us know via a Comment