Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 9 Oct 2019 15:00:00 -0400

Whenever I encountered that, I treated it as a network issue. And it always turned out to be one. Not sure about the detailed explanation. Tanel is way better than me in that respect.

Regards

On 10/9/19 2:55 PM, kunwar singh wrote:

Hi Mladen,
This wait is confusing. If i see this link , https://dbakevlar.com/2014/03/oracle-sqlnet-wait-events/ it means doesnt include network timings. Does your above explanation mean that below is wrong?

Wait represents the time it takes to pack data.
Doesn’t include network timing

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

References:
- How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
  - From: kunwar singh
- Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
  - From: Mladen Gogala
- Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query
  - From: kunwar singh

Other related posts:

» How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kunwar singh
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Dominic Brooks
» RE: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Mark W. Farnham
» RE: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Dominic Brooks
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Andy Sayer
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kunwar singh
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Andy Sayer
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Mladen Gogala
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kunwar singh
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query - Mladen Gogala
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kyle Hailey
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Mladen Gogala
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Kellyn Pot'Vin-Gorman
» RE: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Mark W. Farnham
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kunwar singh
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Andy Sayer
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- Jonathan Lewis
» Re: How to trace the root cause of "SQL*Net more data to client" for only few executions of a query- kunwar singh