溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
下面測試來至于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. |
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
