Re: Puzzling - can't find events that are set for other sessions including 10046 in 12.1

System event array is just used for initializing event settings at both process and session level.

There's a chance that someone has set an ORADEBUG EVENT (process level) instead of ORADEBUG SESSION_EVENT (session level) for your PX processes and since PX processes linger around, even if a new session reuses it for a new query, the process level event will do tracing.

Connect to one of the process SPIDs (that generate traces) and run ORADEBUG EVENTDUMP PROCESS and see what it says?

Thanks,
Tanel.

On Tue, Jan 7, 2020 at 11:57 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Ok, nothing there either.
>
> Is there a way to grep an OS process flag to see if its set inside a
> process on Linux?
>
> Thanks,
> Chris
>
>
> On Tue, Jan 7, 2020 at 11:52 AM Tanel Poder <tanel_at_tanelpoder.com> wrote:
>
>> Hi Chris,
>>
>> Also check DBA_ENABLED_TRACES, the flexible-scoped tracing set up using
>> DBMS_MONITOR.SERV_MOD_ACT_TRACE doesn't show up as a visible event in
>> event-dumps.
>>
>> By the way, talking about events & dumps, I'm doing an Oracle state
>> objects & system state dump reading hacking session tomorrow 8. Jan 12pm
>> EST. Details here:
>>
>> https://twitter.com/TanelPoder/status/1214579375108173824
>>
>> Thanks,
>> Tanel.
>>
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l