SMC Tomcat Talks To Oracle Database A Lot
Passing this along for the good of the community.
Debugging why SMC is so very slow for a particular customer. Finally realized that SMC Tomcat communicates a lot with the Oracle database. Just refreshing the SMC window in your browser will result in around 180 TCP communications between the javaw Tomcat process and the Oracle database.
In chrome developer tools we see the network response for REST calls to the cloud gateway take 10, 20 and 30 seconds where for us these are all just a few miniseconds.
Now we know the problem lies with all these many calls to the Oracle database.
HTH