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@xxxxxxxxx> 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