| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to determine the values for database events that have been set
Hi Mladen,
Sorry to have taken so long to reply. Have been busy at work.
Yes, query works like a charm. You've come through with the goods once again. Thanks! How did u find out about it? I trolled all day through metalink with different subjects along the lines of "event" and it came up with nothing.
L
Here is a litle something that might help:
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;
/
SQL> alter session set events='10046 trace name context forever, level 10';
Session altered.
SQL> @read_events
Event 10046 set at level 10
PL/SQL procedure successfully completed.
This, of course, reads events for the current session, but if events are set on a database level, that means that they're set for each session. Needless to say, you need to be able to execute sys.dbms_system, which means the DBA role.
 |
 |