Database Administration (MOSC)

MOSC Banner

Application Sessions waiting on SQL*Net message from client

edited Jun 16, 2016 5:41AM in Database Administration (MOSC) 9 commentsAnswered

Hi Team,

Our application Team has reported that they are getting the below error code while executing any queries at the database end. However DB connection is fine:

The error they are getting is: Connection timeout occured.

When check from the DB end:

SQL> select SID,EVENT,P1TEXT,P1,P2TEXT,P2,SECONDS_IN_WAIT/3600 "Time in Mins",wait_time from v$session_wait where event like '%message from client%';

       SID EVENT                          P1TEXT                       P1 P2TEXT                       P2 Time in Mins  WAIT_TIME

---------- ------------------------------ -------------------- ---------- -------------------- ---------- ------------ ----------

        11 SQL*Net message from client    driver id            1413697536 #bytes                        1   .001111111          0

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