Events Dump

To dump the events set for the current session:

  ALTER SESSION SET EVENTS 'immediate trace name events level level';

Levels are:

Level Description
1 Session
2 Process
4 System

The following ORADEBUG command has the same effect:

  ORADEBUG DUMP EVENTS level

In Oracle 11.2 and above events can also be dumped using the EVENTDUMP action which has the following syntax:

  EVENTDUMP (GROUP)

where <GROUP> is one of "system", "process" or "session"

For example:

  ALTER SESSION SET EVENTS 'immediate eventdump(system)';
  ALTER SESSION SET EVENTS 'immediate eventdump(session)';
  ALTER SESSION SET EVENTS 'immediate eventdump(process)';

Alternative ORADEBUG commands are:

  ORADEBUG EVENTDUMP SYSTEM
  ORADEBUG EVENTDUMP SESSION
  ORADEBUG EVENTDUMP PROCESS

Note that EVENTDUMP may work in earler Oracle database versions.

For addtional information see:

  ORADEBUG DOC EVENT ACTION EVENTDUMP