List events in session, process or system

There is a new command in 11g to display the current events, which is oradebug eventdump.

For instance :

SQL> alter session set events '10046 trace name context forever,level 12:942 trace name ERRORSTACK level 3';

SQL> oradebug setmypid
Statement processed.
SQL> oradebug eventdump session
sql_trace level=12
942 trace name ERRORSTACK level 3

Read metalink note 436036.1

In 10g and before, the command was oradebug dump events 1 and the list was dumped in a trace file, 11g directly outputs to the console.

Note there is no backward compatibility with unsupported tools like oradebug.
In 11g you will get an ORA-76 with dump events

SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump events 1
ORA-00076: dump EVENTS not found
$ oerr ora 76
00076, 00000, "dump %s not found"
// *Cause:  An attempt was made to invoke a dump that does not exist.
// *Action: Type DUMPLIST to see the list of available dumps.

Published by

Laurent Schneider

Oracle Certified Master

2 thoughts on “List events in session, process or system”

  1. Hi,

    Thank you for info.
    In 10.2, it seems to work:

    SQL> oradebug setmypid
    Statement processed.
    SQL> oradebug eventdump session
    10270 trace name CONTEXT level 10, forever
    SQL> show parameter event

    NAME TYPE VALUE
    ———————————— ———- ——————————
    event string 10270 trace name context forev
    er, level 10
    SQL> @checkv

    BANNER
    —————————————————————-
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – 64bi
    PL/SQL Release 10.2.0.2.0 – Production
    CORE 10.2.0.2.0 Production
    TNS for Solaris: Version 10.2.0.2.0 – Production
    NLSRTL Version 10.2.0.2.0 – Production

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>