ORACLE configuration event parameters
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.
