I’m not sure ash and ash hist show events for idle events..
On Feb 9, 2021, at 7:41 PM, Rich J <rich242j@xxxxxxxxx> 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@xxxxxxxxxxx<mailto:moustafa_dba@xxxxxxxxxxx>> 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@xxxxxxxxx<mailto:rich242j@xxxxxxxxx>> 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@xxxxxxxxxxx<mailto:moustafa_dba@xxxxxxxxxxx>> 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 ?
--
//www.freelists.org/webpage/oracle-l
