Hi Amir,

This is the way to find it.

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

Regards
Mindaugas Navickas

PS I am not author of this script and I do not know whom to credit for it.

--- "Hameed, Amir" <Amir.Hameed@(protected):

> Hi Folks,
> Is there a way to find out all the events that are currently set in an
> instance?
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l