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 ??
Printable View
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:
Is that of any help?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;
/
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.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.