Categories
11g dba sqlplus

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.

By Laurent Schneider

Oracle Certified Master

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

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.