OTM Application Slowness (Doc ID 1579741.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

OTM Production instance suddenly became slowThe login page was appearing, but the users were experiencing extreme slowness while logging-in to the Application. At this point of time, the production Database was accessible as usual through SQL Developer/TOAD. There was no resource intensive activity going on at that moment. The message processing via the Integration also began to slow down.

After sometime, the users were not able to login to the Application itself. The login screen was hanging and the message processing became further slow. We could see that the transmissions were moving from DEFAULT Appserver to the FAILOVER Appserver. On the FAILOVER Appserver also the message processing was extremely slow. No object locks were observed at the Application level, and other servlets like Mediator, ProcessWalker, ObjectLock were not accessible for any kind of analysis. The Database was still accessible through SQL Developer/TOAD.

It could be seen that transmissions were toggling between the DEFAULT Appserver and the FAILOVER Appserver. Overall, the transmissions processing had become extremely slow. When the message processing via Integration had almost stopped, the Integration had to be shut down. Connection errors were seen in the Appserver logs

After the bounce, things were back to normal i.e. login to the Application, message processing etc. started to happen as usual.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.