Found a helpful PL/SQL block in this presentation:
http://www.sagelogix.com/idc/groups/public/documents/sagelogix-presentation/sage016048.pdf – NO LONGER EXISTS
This shows you which events are set – i.e. by an alter system set events command. I modified this to have a larger range of event values – to 29999.
declare event_level number; begin for i in 10000..29999 loop sys.dbms_system.read_ev(i,event_level); -- note: requires exec permission for DBMS_SYSTEM if (event_level > 0) then dbms_output.put_line ('Event '||i||' set at level '|| event_level); end if; end loop; end; /
This shows the events that were set dynamically as well as any set in the init parameter event.
alter system set events '10503 trace name context forever, level 4000';
Then run the PL/SQL block and you get this:
Event 10503 set at level 4000
Also, Oracle note 160178.1 has a good explanation of setting events dynamically and in an spfile.