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