Pega OOTB config making new DB connections every minute

DBA is reporting that the number of logins per minute is high which is not supposed to happen with a connection pool because the new connections can be expensive.

We observed that the connections/database sessions are not long lasting, they are getting re-connected every minute irrespective of the number of connections.

We tried increasing the initialsize, minidle, maxidle values and also tried using direct DB connection string instead of ldaps but it is not solving the problem. We found that the OOTB DBCP factory is causing this behaviour.

DBA report:

Pega is making connections everytime into the DB. (not using your java connection pool)

DB is omni_app_d_coloc   COUNT(*) OS_USERNAME  DBUSERNAME     USERHOST                             TERMINAL   CLIENT_PROGRAM_NAME   TO_CHAR(EVENT ---------- ------------ -------------- ------------------------------------ ---------- --------------------- -------------        198 pegauser     OMNIAPPUSER    omni-dev-web-6fb4676444-z5sj4        unknown    Bootstrap             2025-07-17 10        125 pegauser     OMNIAPPUSER    omni-dev-batch-7c5ffb7965-5k2rs      unknown    Bootstrap             2025-07-17 11        131 pegauser     OMNIAPPUSER    omni-dev-batch-7c5ffb7965-gtnvb      unknown    Bootstrap             2025-07-17 11        124 pegauser     OMNIAPPUSER    omni-dev-bix-6c8f454c4c-rgp44        unknown    Bootstrap             2025-07-17 11        149 pegauser     OMNIAPPUSER    omni-dev-web-6fb4676444-t8hhf        unknown    Bootstrap             2025-07-17 11        214 pegauser     OMNIAPPUSER    omni-dev-web-6fb4676444-z5sj4        unknown    Bootstrap             2025-07-17 11        109 pegauser     OMNIAPPUSER    omni-dev-batch-7c5ffb7965-5k2rs      unknown    Bootstrap             2025-07-17 12        132 pegauser     OMNIAPPUSER    omni-dev-batch-7c5ffb7965-gtnvb      unknown    Bootstrap             2025-07-17 12        138 pegauser     OMNIAPPUSER    omni-dev-bix-6c8f454c4c-rgp44        unknown    Bootstrap             2025-07-17 12        152 pegauser     OMNIAPPUSER    omni-dev-web-6fb4676444-t8hhf        unknown    Bootstrap             2025-07-17 12        210 pegauser     OMNIAPPUSER    omni-dev-web-6fb4676444-z5sj4        unknown    Bootstrap             2025-07-17 12 DB is omnisnd_app_t_coloc                                                                                      COUNT(*) OS_USERNAME  DBUSERNAME     USERHOST                             TERMINAL   CLIENT_PROGRAM_NAME   TO_CHAR(EVENT ---------- ------------ -------------- ------------------------------------ ---------- --------------------- -------------       2736 pegauser     OMNIAPPUSER    omni-sandbox-batch-755dc75cf6-2n6s9  unknown    Bootstrap             2025-07-17 11       2742 pegauser     OMNIAPPUSER    omni-sandbox-batch-755dc75cf6-sl479  unknown    Bootstrap             2025-07-17 11       2760 pegauser     OMNIAPPUSER    omni-sandbox-bix-59bbd9fdf4-flv57    unknown    Bootstrap             2025-07-17 11       2736 pegauser     OMNIAPPUSER    omni-sandbox-web-78c599966c-qwmsl    unknown    Bootstrap             2025-07-17 11       2736 pegauser     OMNIAPPUSER    omni-sandbox-web-78c599966c-rgcrm    unknown    Bootstrap             2025-07-17 11       2664 pegauser     OMNIAPPUSER    omni-sandbox-batch-755dc75cf6-2n6s9  unknown    Bootstrap             2025-07-17 12       2624 pegauser     OMNIAPPUSER    omni-sandbox-batch-755dc75cf6-sl479  unknown    Bootstrap             2025-07-17 12       2644 pegauser     OMNIAPPUSER    omni-sandbox-bix-59bbd9fdf4-flv57    unknown    Bootstrap             2025-07-17 12       2664 pegauser     OMNIAPPUSER    omni-sandbox-web-78c599966c-qwmsl    unknown    Bootstrap             2025-07-17 12       2664 pegauser     OMNIAPPUSER    omni-sandbox-web-78c599966c-rgcrm    unknown    Bootstrap             2025-07-17 12