RE: how to determine what events are set

you can use this for finding session events:  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;
 /
With Best Wishes & Prayers,
Abhishek Saxena.
Mail - abhisheks_at_kpitcummins.com
Tel - +91 20 25458277.
Mob - +91 20 33306103.
www.kpitcummins.com
(A SEI CMM Level 5 Company)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DEEDSD_at_Nationwide.com Sent: Tuesday, December 07, 2004 10:10 PM To: oracle-l_at_freelists.org
Subject: how to determine what events are set

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

• Attached file included as plaintext by Ecartis --
• File: events_session.txt
• Desc: events_session.txt

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;
 /
--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 08 2004 - 05:31:47 CST