ORACLE 配置event参数
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
10235 trace name context forever,level 512
10015 trace name context forever,level 1
www.htz.pw >> 其实这里我们还可以使用reset event scope=spfile sid='*'来操作
System> www.htz.pw > startup force;
ORACLE instance started.
Total System Global Area379965440 bytes
Fixed>
Variable> Database Buffers 201326592 bytes
Redo Buffers 4415488 bytes
Database mounted.
Database opened.
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
Statement processed.
页:
[1]