0

We have some software that is throwing an exception "Pooled connection request timed out"

I know the reason for this and i know the fix. I just need to buy some time on the production server until i can release the software update.

Currently the software establishes about 640 simultaneous connections before it starts throwing this exception.

What database settings can i change which will increase the amount of simultaneous connections?

0

You might want to check the SESSIONS parameter, which controls the maximum number of sessions for the system:

SELECT name, value 
FROM v$parameter
WHERE name = 'sessions';

https://docs.oracle.com/database/121/REFRN/GUID-52804B5A-164F-44F3-8980-F2593B58D807.htm#REFRN10197

You can also verify that there isn't a limit configured via user profile. Query the DBA_PROFILES view to check if a value is assigned for the SESSIONS_PER_USER parameter associated with your user:

select profile, resource_name, limit
from dba_profiles
where resource_name = 'SESSIONS_PER_USER';

Info regarding profiles: https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

  • So the sessions value is set to 504 but im getting 640ish connections before it fails. Sessions_Per_User is set to UNLIMITED. Any further ideas? – CathalMF Mar 14 at 14:59
  • Have you verified that many connections via v$session? Are you connecting via shared server or dedicated server? Also, you can try to increasing the value for the SESSIONS parameter. – John A Mar 14 at 15:23
  • The software takes up exactly 100 sessions every time, never changes. Its a dedicated server. – CathalMF Mar 14 at 15:28
  • You can also check resource usage: docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/… – John A Mar 14 at 15:34
0

Can you please check connection pool setting from application server?

Also, you can increase number of sessions per user by updating profile

Find profile for user:

SELECT profile FROM dba_users
WHERE username = '&user';

Alter profile

ALTER PROFILE  <profile_name>
SESSIONS_PER_USER <value>;

Can create new profile and assign to user:

ALTER PROFILE <profile_name> LIMIT
SESSIONS_PER_USER <value>;

ALTER USER PROFILE <profile_name>; 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.