Application Sessions waiting on SQL*Net message from client
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