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

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

當前題目：Oracle查看新系統(tǒng)的event
標題路徑：http://jinyejixie.com/article44/iehdhe.html

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

廣告

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