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

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