Re: sqlnet more data from client per SQL

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