ITPub博客

首页 > IT基础架构 > 网络安全 > How to set multiple events

How to set multiple events

原创 网络安全 作者:qsxing 时间:2007-03-07 18:10:50 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/188692/viewspace-903288/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    42
  • 访问量
    419217