Question: If you have to set more than one event in the init.ora, how can you specify multiple events on the same line?
The syntax to specify multiple events in the init.ora is:
event="[event 1]:[event 2]: [event 3]: [event n]"
you can also split the events on multiple lines by using the continuation “\” backslash character at the end of each event and continue the next event on the next line. Such As:
event="[event 1]:\ [event 2]:\ [event 3]: \ [event n]"
For Example:
event="\ 10210 trace name context forever, level 10:\ 10211 trace name context forever, level 10:\ 10231 trace name context forever, level 10:\ 10232 trace name context forever, level 10"
After setting the events, bounce the instance and be sure to check the alert.log and verify if the events are in effect. The alert.log should show the events that are in effect, for example:
System parameters with non-default values: ... event = "10210 trace name context forever, level 10:10211 trace name context forever, level 10:10231 trace name context forever, level 10:10232 trace name context forever, level 10" ...
It is also possible to set multiple events in multiple subsequent lines in the init.ora, e.g.
event="10210 trace name context forever, level 10" event="10211 trace name context forever, level 10" event="10231 trace name context forever, level 10"
Note that using the separate lines it is essential to set the events on subsequent lines. Otherwise, only the last event will be used due to the generic parsing of the init.ora values.
NOTE:
For current Oracle versions. e.g. 11g, you can also use the next commands to list the set event in a trace file:
SQL> alter session set events 'immediate eventdump(session)'; SQL> alter system set events 'immediate eventdump(system)';