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

From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: Fri, 9 Jun 2006 12:32:07 -0400 (EDT)
Message-ID: <20060609163207.65377.qmail@web30107.mail.mud.yahoo.com>

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_at_xerox.com> 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

Received on Fri Jun 09 2006 - 11:32:07 CDT