dbms_system.read_ev无法获得event 的level

rhys

操作步骤如下：
SQL> alter session set events '10046 trace name context forever,level 12';

Session altered.

SQL> var lev char(20);
SQL> exec dbms_system.read_ev(10046,:lev);

PL/SQL procedure successfully completed.

SQL> print lev

LEV
--------------------------------
0

SQL>

Maclean Liu(刘相兵

SQL> set serveroutput on;

SQL> SQL> DECLARE
  2     event_level number;
  3     begin
  4     dbms_system.read_ev(10046,event_level);
  5     dbms_output.put_line('event_level is ' ||event_level);
  6     end;
  7     /
event_level is 12

PL/SQL procedure successfully completed.

Maclean Liu(刘相兵

SQL>    alter session set events '10046 trace name context forever,level 12';

Session altered.

SQL> var lev number;
SQL> exec dbms_system.read_ev(10046,:lev);

PL/SQL procedure successfully completed.

SQL>
SQL>  print lev;

       LEV
----------
        12

rhys

SQL> select banner 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

SQL> set time on
21:13:54 SQL> alter session set events '10046 trace name context forever,level 12';

Session altered.

21:14:26 SQL> var lev number;
21:14:35 SQL> execute dbms_system.read_ev(10046,:lev);

PL/SQL procedure successfully completed.

21:14:57 SQL> print lev

       LEV
----------
         0

21:15:02 SQL> declare
21:15:11   2  levq number;
21:15:33   3  begin
21:15:34   4  dbms_system.read_ev(10046,levq);
21:16:05   5  dbms_output.put_line('the number is  '||levq);
21:16:31   6  end;
21:16:33   7  /
the number is  0

PL/SQL procedure successfully completed.

21:16:34 SQL>

ALLSTARS_ORACLE

目前没有 11.2.0.4.0 的测试环境可用， 至少在10g中没有该问题