is my READ_EV broken?

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sun, 26 Feb 2012 15:06:53 +0100
Message-ID: <CALH8A91BRQ+c0hAfefGew=nNzHnwWBw4K65gpnPN_0+domt34g_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Sun Feb 26 2012 - 08:06:53 CST