Re: sqlnet more data from client per SQL

True, for the "SQL*Net message from client" event, which is in the Idle class, but would that also be the case for the "SQL*Net more data from client" event that the Op wants, which is in the Network class?

At least it is in 19.6, which may not have been the case in the past, as MOS 34399.1 alludes to when it says the event is usually classed as "idle".

Rich

On Tue, Feb 9, 2021 at 8:26 PM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:

> It does not. You have to set a hidden parameter to make it work. That
> would generate a lot more ash though.
>
> https://blog.orapub.com/20180215/how-to-see-unseen-activity-using-ash-and-sqlnet-message-from-client.html
>
>
> Am 10.02.2021 um 01:47 schrieb Moustafa Ahmed:
>
> I’m not sure ash and ash hist show events for idle events..
>
> On Feb 9, 2021, at 7:41 PM, Rich J <rich242j_at_gmail.com>
> <rich242j_at_gmail.com> wrote:
>
> 
> Hi Mustafa,
>
> I'm not sure. Will the SQL_ID column of V$ACTIVE_SESSION_HISTORY and the
> EVENT# not get you what you're looking for?
>
> Rich
>
> On Tue, Feb 9, 2021 at 6:22 PM Moustafa Ahmed <moustafa_dba_at_hotmail.com>
> wrote:
>
>> Rich
>>
>> It could be any view that has historic data it is only that I need to
>> look at the data joined to a sqlid, nit just how much sql net more data we
>> had on a specific interval..
>>
>> Do you get my point?
>>
>> On Feb 9, 2021, at 7:12 PM, Rich J <rich242j_at_gmail.com> wrote:
>>
>> 
>> Hi Moustafa,
>>
>> Does it have to be a DBA_HIST view? You could use another view that
>> requires the same Diagnostic license pack such as
>> (G)V$ACTIVE_SESSION_HISTORY. Join that to V$EVENT_NAME on the EVENT#
>> columns to display whichever events or classes you like.
>>
>> For what it's worth, on my 19.6 databases, the "SQL*Net more data from
>> client" wait is classified as "Network" and not "Idle".
>>
>> Rich
>>
>> p.s. It looks like DBA_HIST_ACTIVE_SESS_HISTORY may also work for you,
>> again requiring the same Diagnostic pack license to query as above. See
>> also:
>>
>> https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-68A4128C-4F52-4441-8BC0-A66F5B3EEC35
>>
>>
>> On Tue, Feb 9, 2021 at 4:57 PM Moustafa Ahmed <moustafa_dba_at_hotmail.com>
>> wrote:
>>
>>> Hello Listers
>>>
>>> Is there a DBA_HIST view that will show
>>> sqlnet more data from client (as an idle event)
>>>
>>> Per sql execution history ?
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>

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