Re: sqlnet more data from client per SQL

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> 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 <mailto: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
>>> <mailto: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
>>> <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 <mailto: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>
>>>
>>>

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