Re: sqlnet more data from client per SQL

From: Rich J <rich242j_at_gmail.com>
Date: Tue, 9 Feb 2021 18:58:36 -0600
Message-ID: <CAANsBX1srLCcDt-4Kk8qKhQ1dt_QA-e4TdcYnxBv+eijuKNVYQ_at_mail.gmail.com>

The best way to know for sure is to look (again, provided one has the proper license to do so):

SELECT

ash.sample_Time,
ash.session_id,
ash.session_serial#,
ash.sql_id,

en.DISPLAY_NAME,
en.WAIT_CLASS
FROM v$active_session_history ash
JOIN v$event_name en ON ash.event# = en.event# WHERE en.wait_class = 'Idle';

I get a bunch of rows returned even in my test database that's been sitting idle (so to speak).

Also, remember that the specific event you had said you were looking for is in the "Network" class and not "Idle", at least in my versions of Oracle.

Rich

On Tue, Feb 9, 2021 at 6:47 PM Moustafa Ahmed <moustafa_dba_at_hotmail.com> wrote:

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

Received on Wed Feb 10 2021 - 01:58:36 CET