How to set multiple events

How to set multiple events[@more@]

in spfile:
the name is 'event' and values are quoted then comma separated as in:
ALTER SYSTEM SET event='10235 trace name context forever, level 2','27072 trace name errorstack level 3' COMMENT='TEST' SCOPE=SPFILE;

If bad syntax, you will get ORA-2194 at next database restart. so double check and copy old spfile just in case.

You can remove all events with:
ALTER SYSTEM RESET EVENT SCOPE=SPFILE SID='*' ;

in memory:
the name is 'events' and values are column-separated then quoted as in:
ALTER SYSTEM SET events='10235 trace name context forever, level 2:27072 trace name errorstack level 3';

in pfile:

- the name is 'event' and values are column-separated then quoted as in:
event='10235 trace name context forever, level 2:27072 trace name errorstack level 3'

- or set parameters one by one (must follow eachother):
event='10235 trace name context forever, level 2'
event='27072 trace name errorstack level 3'

Finally here is the event syntax (from http://www.larsditzel.de/9iquickref.pdf)

{ alter system set event = | alter session set events [=] } ‘ trace name context {forever, level | off}’

alter session set events [=] {
‘immediate trace name { heapdump | blockdump | treedump | controlf | systemstate | buffers } level ’
| ‘ trace name errorstack level [; name processstate level ]’
}

{ alter system set event = | alter session set events [=] } ‘ trace name context {forever, level | off}’

alter session set events [=] {
‘immediate trace name { heapdump | blockdump | treedump | controlf | systemstate | buffers } level ’
| ‘ trace name errorstack level [; name processstate level ]’
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/188692/viewspace-903288/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/188692/viewspace-903288/