ORACLE 配置event参数

hyht

下面测试来至于11G
1，数据库的版本
www.yunvn.com > select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
2，在spfile中修改event参数
www.yunvn.com > alter system set event='10235 trace name context forever,level 512', '10015 trace name context forever, level 1' scope=spfile;

System altered.

www.yunvn.com > startup force;


www.yunvn.com > @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.yunvn.com > 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
3，在init中修改event参数
方法1
www.yunvn.com > !grep "event" /tmp/123.txt
*.event='10235 trace name context forever,level 512:10015 trace name context forever,level 1'
方法2
www.yunvn.com > !grep "event" /tmp/123.txt
*.event='10235 trace name context forever,level 512'
*.event='10015 trace name context forever,level 1'
方法3：
www.yunvn.com >  !grep -A1 "event" /tmp/123.txt
*.event='10235 trace name context forever,level 512:\
10015 trace name context forever,level 1'
4,清空event的方法
如果使用init参数文件，直接删除event参数，如果使用spfile文件
www.yunvn.com > @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.yunvn.com > alter system set event='' scope=spfile ;
其实这里我们还可以使用reset event scope=spfile sid='*'来操作
System altered.

www.yunvn.com > startup force;
ORACLE instance started.

Total System Global Area  379965440 bytes
Fixed Size                  2253464 bytes
Variable Size             171969896 bytes
Database Buffers          201326592 bytes
Redo Buffers                4415488 bytes
Database mounted.
Database opened.
www.yunvn.com > @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.