Re: how to determine what events are set

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@xxxxxxxxxxxxxx
<DEEDSD@xxxxxxxxxxxxxx> 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

Other related posts: