当前位置: 首页 > EVENT > 正文

ORACLE 配置event参数

下面测试来至于11G

1,数据库的版本

www.htz.pw > 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.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

3,在init中修改event参数

方法1

www.htz.pw > !grep “event” /tmp/123.txt

*.event=’10235 trace name context forever,level 512:10015 trace name context forever,level 1′

方法2

www.htz.pw > !grep “event” /tmp/123.txt

*.event=’10235 trace name context forever,level 512′

*.event=’10015 trace name context forever,level 1′

方法3

www.htz.pw >  !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.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 > alter system set event=” scope=spfile ;

其实这里我们还可以使用reset event scope=spfile sid=’*’来操作

System altered.

 

www.htz.pw > 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.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.

本文固定链接: http://www.htz.pw/2014/05/12/oracle-%e9%85%8d%e7%bd%aeevent%e5%8f%82%e6%95%b0.html | 认真就输

该日志由 huangtingzhong 于2014年05月12日发表在 EVENT 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: ORACLE 配置event参数 | 认真就输