Re: sqlnet more data from client per SQL

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

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 Received on Wed Feb 10 2021 - 01:47:43 CET