DBMS_SYSTEM.SET_EV Procedure

This procedure enables/disables events in another session.

Argument Name	Type	In/Out	Default?
SI	BINARY_INTEGER	IN
SE	BINARY_INTEGER	IN
EV	BINARY_INTEGER	IN
LE	BINARY_INTEGER	IN
NM	VARCHAR2	IN

The parameters are:

Parameter	Description
SI	SID
SE	Serial Number
EV	Event Number
LE	Level
NM	Action Name

For example to enable event 10046, level 4 in a session with SID 9, serial# 29 use:

EXECUTE dbms_system.set_ev (9, 29, 10046, 4, '');

To disable event 10046 in the same session use:

EXECUTE dbms_system.set_ev (9, 29, 10046, 0, '');

The SID and serial# for the session can be obtained from V$SESSION e.g.:

DECLARE
    l_sid NUMBER;
    l_serial NUMBER;
BEGIN
    SELECT sid, serial#
    INTO l_sid, l_serial
    FROM v$session
    WHERE username = 'User1';

    dbms_system.set_ev (l_sid, l_serial, 10046, 4, '');
END;
/