Re: How to find events that are currently set in an instance
- From: Mindaugas Navickas <mnavickas@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Jun 2006 12:32:07 -0400 (EDT)
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
