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

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.
>
> On Tue, Jan 7, 2020 at 10:42 AM Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> I'm trying to list ALL events set in my SYSTEM (Oracle RAC 12.1)
>>
>> I've got a phantom 10046 trace set somewhere but I'm having difficulty
>> finding it. (As the tracefiles only show up on parallel query processes)
>>
>> I've purposefully set a new 10046 trace on a session that is running a
>> long SQL and it's not being listed/found either.
>>
>> Here's what I've tried:
>> 1. select sid,serial# from gv$session where nvl(SQL_TRACE,' ') !=
>> 'DISABLED' ;
>> (no rows)
>> So 10046 doesn't set SQL_TRACE on the session level for gv$session
>> apparently.
>>
>> 2. oradebug
>> SQL> oradebug setmypid
>> Statement processed.
>> SQL> oradebug tracefile_name
>>
>> /u02/app/oracle/diag/rdbms/sentry_exa_mia/sentry1/trace/sentry1_ora_223206.trc
>> SQL> oradebug eventdump system
>> Statement processed.
>>
>> Nothing returned and nothing in the tracefile indicating a 10046 trace is
>> set
>>
>> 3. Explore using DBMS_SYSTEM.READ_EV but that's only for a session
>>
>> So, how do you list ALL the events that are set system wide in 12.1 ?
>>
>> Chris
>>
>>

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