RE: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
Date: Wed, 9 Oct 2019 17:45:00 +0000
Message-ID: <DB7PR04MB44431094772DBFEF6397F5DEA1950_at_DB7PR04MB4443.eurprd04.prod.outlook.com>
And you can set sql tracing on for a particular sql id, when/if it arrives it gets traced. Later you can turn it off. Provided that capturing all trace files for 500 odd executions until you get a slow one doesn’t cause you any issues.
http://tech.e2sn.com/oracle/troubleshooting/oradebug-doc
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
From: Mark W. Farnham <mwf_at_rsiz.com>
Sent: Wednesday, October 9, 2019 6:33:17 PM To: dombrooks_at_hotmail.com <dombrooks_at_hotmail.com>; krishsingh.111_at_gmail.com <krishsingh.111_at_gmail.com> Cc: 'ORACLE-L' <oracle-l_at_freelists.org> Subject: RE: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
and (not but) are different client programs or client locations the “catchers” of the data?
if different, seeing if the slow ones are consistently of a type could be useful in diagnosis and prevention.
a VLAN with no real QOS (even if configured and promised) can also correlate with this, especially if the physical LAN is used for video.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dominic Brooks
Sent: Wednesday, October 09, 2019 1:16 PM
To: krishsingh.111_at_gmail.com
Cc: ORACLE-L
Subject: Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
What arraysize is being used ? What’s the average row size?
https://blog.tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fblog.tanelpoder.com%2F2008%2F02%2F10%2Fsqlnet-message-to-client-vs-sqlnet-more-data-to-client%2F&data=02%7C01%7C%7C90104c6c1b554669ef2108d74cded508%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637062392246215344&sdata=mLWNt9t50vSZ3mP4IDioLeAmouhmmfaC%2FuC3mrt5iuc%3D&reserved=0> Sent from my iPhone
On 9 Oct 2019, at 17:32, kunwar singh <krishsingh.111_at_gmail.com<mailto:krishsingh.111_at_gmail.com>> wrote:
Hi Listers,
For other executions we dont see that wait event being a problem.
Our customer have one job which runs daily and one of the sqls which executes like 500 times had 5 odd executions where it runs slower and most of the time is being spent on "SQL*Net more data to client" . Normal run times are like few seconds and the longer run times are like 1 hour or so.
What kind of tracing can we do to go in depth of the issue. I want to be sure before i suggest some tuning at SDU sizing level etc. Because we cannot predict when the slow run of the query will happen we cannot wait for it and then run strace etc exactly at that time ,Basically we will have to automate the tracing step.
--
Cheers,
Kunwar
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 09 2019 - 19:45:00 CEST