Packages

PROCEDURE DBMS_SYSTEM.SET_EV

This procedure enables/disables events in another session

The parameters are

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;
    /