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_at_gmail.com>
Date: Wed, 9 Oct 2019 15:00:00 -0400
Message-ID: <4d5331d3-cee2-313b-4683-ef98afc8dd42_at_gmail.com>
Date: Wed, 9 Oct 2019 15:00:00 -0400
Message-ID: <4d5331d3-cee2-313b-4683-ef98afc8dd42_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 09 2019 - 21:00:00 CEST