We are facing this DB slowness issue. When we researched, we found that tomcat is using default dbcp connection pool. So, we changed context.xml in tomcat server to use jdbc connection pool.

by adding factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" because jdbc is more efficient than dbcp. After updating context.xml, we cannot start the nodes due to this error: java.sql.SQLException: Resultset closed at org.apache.tomcat.jdbc.pool.statementfacade. We are using oracle 19, tomcat 9.0.93, JDK 11 , Pega 23

Anybody faced this issue before.

We already tried this solution as mentioned in the article: https://support.pega.com/question/commons-dbcp-vs-tomcat-jdbc-pool