Determine what system events are set

Does anyone know of a query or what system table(s) or view(s) that will tell me what system events have been set for an instance ??

If you use dbms_system.read_ev:

Code:

---

set serveroutput on
declare
event      binary_integer:=0;
statistics  binary_integer:=0;
begin       
for event in 10000..10999 loop
sys.dbms_system.read_ev(event,statistics);
if statistics=1 then
dbms_output.put_line('Event :'||event||' Value :'||statistics);
end if;
end loop;
end;
/

---

Is that of any help?

Julian.

I use procedure like ur. Sometimes it works, sometimes not.
I tried to reserch why it happendd, but i could not, without stabe results.
This is possible problem with this script.

Quote:

---

Originally posted by Shestakov
Julian.

I use procedure like ur. Sometimes it works, sometimes not.
I tried to reserch why it happendd, but i could not, without stabe results.
This is possible problem with this script.

---

I see. Some events might be out of the range 10000..10999, which is not very common. I suggest that events stay in the init.ora so you (the DBA) can determine what is set based on the init file. I personally would set an even only after the recommendation of Oracle support.