如何检查系统中已设置的Oracle Event事件

Maclean Liu(刘相兵

如何检查系统中已设置的Oracle Event事件


alter system set events '1 trace name errorstack forever,level 10';          ==> 设置 EVENT 1 TRACE ERRORSTACK LEVEL 10的事件



SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump events 2;
Statement processed.
SQL> oradebug tracefile_name;
/s01/admin/G10R21/udump/g10r21_ora_3935.trc


TRACE文件中可以找到以下信息：

Dump event group for level PROCESS
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life
755F800 1       1       755f890 0 0
        TR Name             TR level   TR address       TR arm     TR life    TR type
        ERRORSTACK                   10 0         -1          2          0

event 1 ERRORSTACK LEVEL 10




SQL> alter system set events '1 trace name errorstack off';                ==> 取消 EVENT 1 TRACE ERRORSTACK的事件

System altered.

SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump events 2 ;
Statement processed.
SQL> oradebug tracefile_name;
/s01/admin/G10R21/udump/g10r21_ora_4105.trc


Dump event group for level PROCESS
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life

NO EVENT THERE!

teapot

How To List All The Named Events Set For A Database [ID 436036.1]