Using "oradebug dump events 1" one can find/list events set in a session. For example: In a session events 10046 and 1410 events are set SQL> ALTER SESSION SET EVENTS='10046 trace name context forever, level 12'; Session altered. SQL> ALTER SESSION SET EVENTS='1410 trace name context forever, level 12'; Session altered. SQL> SELECT distinct sid … Continue reading How to find/list the events set in a session? →