Connections that go over DB Links are randomly getting stuck waiting on single-task message
I have an intermittent problem with sessions hanging waiting on single-task message.
Supposedly this is: When running single task, this event indicates that the session waits for the client side of the executable.
I’m not sure exactly the ‘Client Side’ is in this case.
I think the simple Description is saying ‘Your App’ made a request from the DB, we sent a response back and we are waiting on it.” In other support notes where the issue is the far side of a DB Link connection.
Out App tier is deployed in Cloud Foundry ‘App Containers’. The original thinking was that bouncing those app containers were orphaning these sessions and causing this problem. I have demonstrated that is NOT the case. These sessions are hung HARD and have to be killed from the OS level. As such reinitializing a Cloud Foundry App Container will leave hung sessions with the old ‘Machine Identifier’ listed in Oracle, but they were hung BEFORE the App Container was Bounced.