Hello folks, we just currently deploy DAM solution for our customer, main DB usage is Oracle. The problem we are encounter is that since the deployment, the DB response time is very slow, we have to reduce the number of security policy to just one and only after that the DB response time is going back to normal rate.
Using /proc/hades/status for monitoring, we see that the TPS and maximum TPS is normal, which mean the Gateway is not overload.
So my question is what might be the cause of this issue and what can we do to fix it ? Thank you and much appriciated
#DatabaseActivityMonitoring------------------------------
Chau Vo Ba
Technical Support
Ho Chi Minh
------------------------------