Database Networking (MOSC)

MOSC Banner

Connections that go over DB Links are randomly getting stuck waiting on single-task message

edited Sep 8, 2020 5:01AM in Database Networking (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center