Re: How to find events that are currently set in an instance

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@xxxxxxxxx> wrote:

> 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

Other related posts: