Re: sqlnet more data from client per SQL

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