DBMS_SYSTEM.READ_EV Procedure

This procedure returns the current level for a specified event.

Argument Name	Type	In/Out	Default?
IEV	BINARY_INTEGER	IN
OEV	BINARY_INTEGER	OUT

The SET_EV procedure enables/disables events in another session

The parameters are:

Parameter	Description
IEV	Event
OEV	Level

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

Note that internal events exist outside this range.