is my READ_EV broken?

From: Martin Berger <martin.a.berger@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Sun, 26 Feb 2012 15:06:53 +0100

Hi list,
I'm facing a strange problem, maybe someone can help me to figure out my
errors.
I try to follow the testcase in the book "Secrets of the Oracle Database"
[1] pages 204/205:

Examples

The following example shows that using DBMS_MONITOR in Oracle10g to enable
tracing of SQL statements and wait events set event 10046 at level 8:

SQL> VARIABLE lev number
SQL> SET AUTOPRINT ON
SQL> EXECUTE sys.dbms_system.read_ev(10046, :lev)
PL/SQL procedure successfully competed.
       LEV
----------
         0
SQL> EXEC dbms_monitor.session_trace_enable
PL/SQL procedure successfully completed
SQL> SELECT sql_trace, sql_trace_waits, sql_trace_binds FROM v$session
WHERE sid=userenv('sid')

SQL_TRACE SQL_RACE_WAITS SQL_TACE_BINDS
--------- -------------- --------------
ENABLED   TRUE           FALSE
SQL> EXECUTE sys.dbms_system.read_ev(10046,:lev)
PL/SQL procedure successfully completed
       LEV
----------
         8

my testcase ends with
SQL> EXECUTE sys.dbms_system.read_ev(10046,:lev)
       LEV
----------
 *0*

I run this test at 11.2.0.2.0 - 64 bit on Linux x64 (RedHat), 11.2.0.3.0 -
64 bit on Linux x64 (RedHat)
another test at 10.2.0.5.0 - 64 bit on Linux x64 (RedHat) worked as
expected and described in the book.

does anyone has an idea where I missed the track? Or is it a simple
feature-change in 11.2 ?


thank you,
  Martin


[1]
http://books.google.at/books?id=g1R96D2uO7kC&pg=PA204&lpg=PA204&dq=read_ev&source=bl&ots=d8WFcf6wFW&sig=9aDLp_mM1_gh5P94RRrHPkM2mDw&hl=en&sa=X&ei=9TBKT5vFE9GZhQfiotGeDg&ved=0CFYQ6AEwCA#v=onepage&q=read_ev&f=false


--
//www.freelists.org/webpage/oracle-l

is my READ_EV broken?

Other related posts: