SQL*Net message to client

SQL*Net message to client

The server (foreground process) is sending a message to the client.

这个wait event不是idle的，千万别跟其他wait event搞混了。
他发生在返回数据数据的时候。
如果他突然特别大，有可能网络有问题，也有可能客户端太忙

  The SQL*Net message to client  may indicate a network-related issue that causes clients too long to get data from the database server.  Thus, it can be a TCP issue, but it is not limited to that

Common causes of a high SQL*Net message to client might include TCP/IP bottlenecks or TNS parameter issues:

• High network latency:  Check with netstat to ensure that your TCP/IP does not have bottlenecks.

• Incorrect TNS parameters:  Setting such as tcp.nodelay can impact the time for SQL message to client waits.  See these tips onOracle TNS network tuning .

转载于:https://www.cnblogs.com/zhaoyangjian724/p/3798066.html