proc_show_events.sql

REM Script Name		: proc_show_events.sql
REM Author				: Craig Richards
REM Created			: 11 April 2013 
REM Last Modified	:
REM Version				: 1.0
REM
REM Modifications		:
REM
REM Description		: Create a procedure you can call to show what events are set in the database, this is for sessions mainly, but if they are set in the database they will exist in all sessions

CREATE OR REPLACE PROCEDURE cr_show_events
AS
  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.ENABLE(1000000);
      DBMS_OUTPUT.PUT_LINE('Event '||to_char(i)||' set at level '||
      TO_CHAR(event_level));
    END IF;
  END LOOP;
END;
/