Document 436036.1 SQL> connect / as sysdba SQL> oradebug setmypid Oracle 8i / 9i SQL> oradebug dump events <level> /* Level 1 - Dump session group's event settings /* Level 2 - Dump process group's event settings /* Level 4 - Dump system group's event settings (Ie the instance wide events) Oracle 10g / 11g and above SQL> oradebug eventdump <level> /* session - Dump session group's event settings /* process - Dump process group's event settings /* system - Dump system group's event settings(Ie the instance wide events) Note: level needs to be specified in lowercase ! -- OR -- SQL> alter session set events 'immediate eventdump(<level>)'; /* SESSION - Dump session group's event settings /* PROCESS - Dump process group's event settings /* SYSTEM - Dump system group's event settings(Ie the instance wide events)
