Oracle查看新系統(tǒng)的event

剛接管的新系統(tǒng)，想查看是否設(shè)置了某些事件，方法如下。

陵城網(wǎng)站制作公司哪家好，找創(chuàng)新互聯(lián)！從網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、APP開發(fā)、成都響應(yīng)式網(wǎng)站建設(shè)公司等網(wǎng)站項目制作，到程序開發(fā)，運營維護。創(chuàng)新互聯(lián)從2013年創(chuàng)立到現(xiàn)在10年的時間，我們擁有了豐富的建站經(jīng)驗和運維經(jīng)驗，來保證我們的工作的順利進行。專注于網(wǎng)站建設(shè)就選創(chuàng)新互聯(lián)。

**APPLIES TO:**
Oracle Database - Enterprise Edition - Version 7.1.2.0 to 12.2.0.1 [Release 7.1.2 to 12.2]
Information in this document applies to any platform.

**GOAL：**
There are times when we need to disable or list out the existing oracle diagnostics events set on existing application or any existing Session. This note lists out a worked out example of how to capture existing session or system level diagnostics event set and how to disable them later on after verifying them.

<roidb01:orcl:/home/oracle>$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 16 15:25:43 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@orcl> oradebug setmypid
Statement processed.
SYS@orcl> oradebug eventdump system
Statement processed.
SYS@orcl> alter system set events='10231 trace name context forever,level 10';
System altered.

SYS@orcl> oradebug eventdump system 
10231 trace name context forever,level 10

SYS@orcl> alter system set events='10231 trace name context off';
System altered.

SYS@orcl> oradebug eventdump system
Statement processed.
SYS@orcl> 
SYS@orcl> alter session set events='10231 trace name context forever,level 10';
Session altered.

SYS@orcl> oradebug eventdump session
10231 trace name context forever,level 10
SYS@orcl> alter session set events='10231 trace name context off';
Session altered.
SYS@orcl> oradebug eventdump session
Statement processed.
SYS@orcl> 

當(dāng)前題目：Oracle查看新系統(tǒng)的event
標(biāo)題路徑：http://muchs.cn/article44/iehdhe.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站營銷、網(wǎng)站收錄、建站公司、Google、微信小程序、云服務(wù)器

廣告

聲明：本網(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)