Re: Sql net msg from client and fetch arrays

Hi Moustafa,

I'm not sure how do you check it and what exactly are you trying to achieve, but this may be interesting for you:  http://orasql.org/2017/11/16/easy-way-to-check-fetchsize/

PS. If you are trying to analyze sqlnet timing, it's better to investigate wait events from session/system statistics, like v$session/system_event, v$sys/sessmetric, vsys/sess_time_model, etc...

Pps. and probably you need "SQL*Net message to client" and "SQL*Net more data to client", instead of "from client": https://tanelpoder.com/2008/02/07/sqlnet-message-to-client-wait-gotcha/ https://tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE Associate
http://orasql.org

пт, 22 янв. 2021 г., 4:08 Moustafa Ahmed <moustafa_dba_at_hotmail.com>:

> Hello lister!
>
> I have couple of question about sql net msg from client..
> 1-considering it is an idle event and it is not sampled at ash or dba_hist
> for ash which views can show which sql_id’s spent most of the time of that
> idle event?
>
> 2-as it sounds odd I can explain why I’m asking when running massive DW
> sql’s that retrieves (unfortunate tens of millions of rows) adding to that
> oracle last execution (when the statement is still fetch rows and feeding
> them to the top row source) it may look confusing to DBA’s and app folks
> That. Wing said we may have a sql which is spending most of the time
> retrieving the rows not processing the rows so if we can spot the weight of
> sql net msg’s from client it can help big deal!
>
> 3-some apps do have variant rows per fetch for different sql’s varying
> from 1000 to 100
> Meanwhile the app itself has the maximum set for rows perf fetch what
> causes that value to change from one sql to another although the app does
> not dictate that?
>
> Thank you,

--
http://www.freelists.org/webpage/oracle-l