oracle TKProf 输出：来自客户端的 SQL*Net 消息
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/633853/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
TKProf Output: SQL*Net message from client
提问by Karl
I am currently in the process of debugging a database performance issue. I have run extended trace on the suffering oracle box to obtain a trace file which I have analyzed using tkprof.
我目前正在调试数据库性能问题。我在受难的 oracle 机器上运行了扩展跟踪以获得我使用 tkprof 分析过的跟踪文件。
One thing that caught my eye straight away was the following output;
立即引起我注意的一件事是以下输出；
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 4 0.00 0.00
SQL*Net message from client 4 109.06 141.31
I have run the relate query manually via a SQL client an it executes in a timely fashion. So I don't think its cause directly by the query.
我已经通过 SQL 客户端手动运行相关查询，并及时执行。所以我不认为它是由查询直接引起的。
Can some one clarify what exactly "SQL*Net message from client" means ?
有人可以澄清“来自客户端的 SQL*Net 消息”的确切含义吗？
Does anyone have any idea what could be causing such large wait times ?
有谁知道是什么导致了如此长的等待时间？
Thanks in advance
提前致谢
Karl
卡尔
回答by Greg Reynolds
SQL*Net message from client means the time taken by oracle waiting for input from the client that you are connecting with. It's often thought to be an "idle" event, so nothing to worry about; however, this link disagrees. You might find that your client is the one taking the time so you could optimise your application not the queries it uses.
来自客户端的 SQL*Net 消息表示 oracle 等待来自您正在连接的客户端的输入所花费的时间。它通常被认为是一个“空闲”事件，所以没有什么可担心的；然而，这个链接不同意。您可能会发现您的客户正在花时间，因此您可以优化您的应用程序而不是它使用的查询。
http://oracletoday.blogspot.com/2005/09/sqlnet-message-from-client.html
http://oracletoday.blogspot.com/2005/09/sqlnet-message-from-client.html
Also, another good link is http://www.dba-oracle.com/m_sql_net_message_to_client.htm
另外，另一个很好的链接是http://www.dba-oracle.com/m_sql_net_message_to_client.htm
回答by Pan.Tian
There is really good post talking about "Oracle: Network Waits"
有很好的帖子谈论“ Oracle：网络等待”
Link:https://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits
链接：https: //sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits
Contents
内容
1 Introduction
2 SQL*Net Wait Events
2.1 SQL*Net message from client
2.2 SQL*Net message to client
2.3 SQL*Net more data to client
2.4 SQL*Net more data from client
2.5 SQL*Net break/reset to client
2.6 DBLINK SQL*Net Waits
3 Analysis and Tuning
3.1 SDU
3.2 RECV_BUF_SIZE and SEND_BUF_SIZE
