ORACLE配置event参数

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

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

方法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' 

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.