Packages

PROCEDURE DBMS_SYSTEM.READ_EV

This procedure returns the current level for a specified event

The SET_EV procedure enables/disables events in another session

The parameters are

In SQL*Plus to check the current level of event 10046 in the current session use

    VAR v_level NUMBER;

    EXECUTE dbms_system.set_ev (10046, v_level);

    PRINT v_level;

The following script lists non-zero levels for all events in the range 10000-10999.

    SET SERVEROUTPUT ON

    DECLARE
        l_level NUMBER;
    BEGIN
        FOR l_event IN 10000..10999 
        LOOP
            dbms_system.read_ev (l_event,l_level);
            IF (l_level > 0) THEN
                dbms_output.put_line ('Event '||TO_CHAR (l_event) ||
                ' is set at level '||TO_CHAR (l_level));
            END IF;
        END LOOP;
    END;
    /