ORACLE 配置event参数

 

> @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

> alter system set event=‘‘ scope=spfile ;

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

System altered.

 

> 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.

> @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.