It does not. You have to set a hidden parameter to make it work. That
would generate a lot more ash though.
https://blog.orapub.com/20180215/how-to-see-unseen-activity-using-ash-and-sqlnet-message-from-client.html
Am 10.02.2021 um 01:47 schrieb Moustafa Ahmed:
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
<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
<//www.freelists.org/webpage/oracle-l>
