Shulou(Shulou.com)06/01 Report--

For the new system you just took over, you want to see if some events are set as follows.

* * 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.$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 16 15:25:43 2019Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSYS@orcl > oradebug setmypidStatement processed.SYS@orcl > oradebug eventdump systemStatement processed.SYS@orcl > alter system set events='10231 trace name context forever,level 10potential system altered.SYS@orcl > oradebug eventdump system 10231 trace name context forever,level 10SYS@orcl > alter system set events='10231 trace name context off';System altered.SYS@orcl > oradebug eventdump systemStatement processed.SYS@orcl > SYS@orcl > alter session set events='10231 trace name context forever,level 10' Session altered.SYS@orcl > oradebug eventdump session10231 trace name context forever,level 10SYS@orcl > alter session set events='10231 trace name context off';Session altered.SYS@orcl > oradebug eventdump sessionStatement processed.SYS@orcl >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.