Database Tuning (MOSC)

MOSC Banner

Suspicious wait on SQL*NET MESSAGE FROM CLIENT

edited Apr 6, 2016 2:35AM in Database Tuning (MOSC) 13 commentsAnswered

Hi everybody,

We have a strange performance problem on Oracle 12.1.2.0. When the server is "loaded" we can see high wait values for:

SQL*NET MESSAGE FROM CLIENT

When tracing an application that run on a client machine.

But when the server is "not loaded" the same application functionality traced shows low values for:

SQL*NET MESSAGE FROM CLIENT

We have seen this kind of figure when the server was "loaded":

 

Elapsed times include waiting on following events:

 

  Event waited on Times   Max. Wait  Total Waited

 

----------------------------------------   Waited ----------  ------------

 

  SQL*Net message to client 20945 0.00          0.07

 

  SQL*Net message from client 20945 0.08         88.43

 

  db file sequential read 23 0.17          0.55

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