SQL*Net message to client wait isn’t really what it’s thought to be | Tanel Poder Consulting

[giscus[bot]]

SQL*Net message to client wait isn’t really what it’s thought to be | Tanel Poder Consulting

In a recent Oracle Forum thread a question came up how to use SQLNet message to client wait events for measuring network latency between server and client. The answer is that you can’t use it for network latency measurements at all, due to how TCP stack works and how Oracle uses it.
I’ll paste my answer here too, for people who don’t follow Oracle Forums:
As I wrote in that reply, “SQLNet message to client” does NOT measure network latency! - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/2008/02/07/sqlnet-message-to-client-wait-gotcha/