Re: how to determine what events are set

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Tue, 7 Dec 2004 23:43:19 +0530
Message-ID: <3b0f44a104120710138586604@mail.gmail.com>

>From Oracle Wait Interface Book, Appendix A

example of dbms_system.read_ev call:

set serveroutput on
declare
  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.put_line('Event '||to_char(i)||' set at level '|| 
                             to_char(event_level)); 
     end if; 

  end loop;
 end;
 /

On Tue, 7 Dec 2004 11:39:52 -0500, DEEDSD_at_nationwide.com <DEEDSD_at_nationwide.com> wrote:
> I think this was answered before on this list (or I heard it in a class)
> but I can't seem to find it. I recall there being a table that can be
> queried to determine which events are set in the database, for a session,
> etc. I can't remember what the name is, though. Anyone remember?
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 

Best Regards,
K Gopalakrishnan 
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 07 2004 - 12:27:03 CST