Shulou(Shulou.com)06/01 Report--

As for 11G, the following test

1, version of the database

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. Modify the event parameter in spfile

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

Clear the value of event

ALTER SYSTEM RESET EVENT SCOPE=SPFILE SID='*'

Actually, we can also use the following methods

It should be noted here that level 512 is followed by: there is no','

Www.htz.pw > alter system set event='10235 trace name context forever,level 512 trace name context forever,level 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. Modify the event parameter in init

Method 1

Www.htz.pw >! grep "event" / tmp/123.txt

* .event='10235 trace name context forever,level 512 10015 trace name context forever,level 1'

Method 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'

Method 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, the method of emptying event

If you use an init parameter file, delete the event parameter directly, if you use a spfile file

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

Actually, we can also use reset event scope=spfile sid='*' to operate here.

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.