www.htz.pw
> alter system set event='10235 trace name context forever,level 512', '10015 trace name context forever, level 1' scope=spfile;
System altered.
www.htz.pw
> startup force;
www.htz.pw
> @dump_event.sql
"***************************************************************************"
"session - Dump session group's event settings
"
"process - Dump process group's event settings
"
"system
- Dump system group's event settings(Ie the instance wide events)
"
"***************************************************************************"
Statement processed.
Enter value for input: system
10015 trace name context forever, level 1
10235 trace name context forever,level 512
清空
event
的值
ALTER SYSTEM RESET EVENT SCOPE=SPFILE SID='*';
其实我们还可以使用下面的方法
这里需要注意的是:
level 512
后面接的:没有
','
www.htz.pw
> alter system set event='10235 trace name context forever,level 512:10015
trace name context forever,level 1' scope=spfile;
System altered.
"***************************************************************************"
"session - Dump session group's event settings
"
"process - Dump process group's event settings
"
"system
- Dump system group's event settings(Ie the instance wide events)
"
"***************************************************************************"
Statement processed.
Enter value for input: system
10235 trace name context forever,level 512
10015 trace name context forever,level 1