True, for the "SQL*Net message from client" event, which is in the Idle
class, but would that also be the case for the "SQL*Net more data from
client" event that the Op wants, which is in the Network class?
At least it is in 19.6, which may not have been the case in the past, as
MOS 34399.1 alludes to when it says the event is usually classed as "idle".
Rich
On Tue, Feb 9, 2021 at 8:26 PM Lothar Flatz <l.flatz@xxxxxxxxxx> wrote:
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>
<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>
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> 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>
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
