I needed to find out if a certain event was set at the database level on my instance. The READ_EV procedure of DBMS_SYSTEM came to my help. Below is a quick way to find out what are the currently set events for your session (session level). It will report all instance wide events too as they are applicable to session also.
In the below example, event_level will be zero if event is not not set at all.
set serveroutput on DECLARE event_level NUMBER; BEGIN FOR i IN 10000..10999 LOOP sys.dbms_system.read_ev(i,event_level); IF (event_level > 0) THEN dbms_output.put_line('Event '||TO_CHAR(i)|| ' set at level '|| TO_CHAR(event_level)); END IF; END LOOP; END;