ORACLE配置event參數(shù)

下面測試來至于11G

10年積累的成都網(wǎng)站建設(shè)、做網(wǎng)站經(jīng)驗，可以快速應(yīng)對客戶對網(wǎng)站的新想法和需求。提供各種問題對應(yīng)的解決方案。讓選擇我們的客戶得到更好、更有力的網(wǎng)絡(luò)服務(wù)。我雖然不認識你，你也不認識我。但先制作網(wǎng)站后付款的網(wǎng)站建設(shè)流程，更有臨邑免費網(wǎng)站建設(shè)讓你可以放心的選擇與我們合作。

1，數(shù)據(jù)庫的版本

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參數(shù)

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參數(shù)

方法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參數(shù)文件，直接刪除event參數(shù)，如果使用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.

網(wǎng)頁名稱：ORACLE配置event參數(shù)
網(wǎng)頁路徑：http://jinyejixie.com/article32/ghhjpc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站排名、網(wǎng)站制作、搜索引擎優(yōu)化、網(wǎng)站維護、App設(shè)計、網(wǎng)站策劃

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容

成人午夜视频全免费观看高清-秋霞福利视频一区二区三区-国产精品久久久久电影小说-亚洲不卡区三一区三区一区

ORACLE配置event參數(shù)