does anyone know if SBM, mainly Tomcat, is using connection pooling (SBM 11.5, Oracle)?
One of our customers moved their AE server to the cloud and kept their db server locally which increased the response time from about 0.5ms to 8ms.
This is causing SBM to be very slow, especcially at boot time and the customer is claiming that it is due to not using connection pooling.
If it really is the case, is there a way to enable it?
There are questions that this post brings up such as you say they moved their AE server to the cloud, what about the Tomcat components were they also on the AE server? But, I mention this only for completeness of understanding the setup.
The likely culprit is the network connection between the AE and database server. Have they established a VPN between the AE and database server. This would allow them to control the reliability of the connection. I have not actually setup this connection myself, but the key to this setup is to control the reliability of the setup.