RE: how to determine what events are set
- From: "Abhishek Saxena" <AbhishekS@xxxxxxxxxxxxxxx>
- To: <DEEDSD@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2004 17:08:09 +0530
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@xxxxxxxxxxxxxxx
Tel - +91 20 25458277.
Mob - +91 20 33306103.
www.kpitcummins.com
(A SEI CMM Level 5 Company)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DEEDSD@xxxxxxxxxxxxxx
Sent: Tuesday, December 07, 2004 10:10 PM
To: oracle-l@xxxxxxxxxxxxx
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?
--
//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;
/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
