EVENT 10053 not working

From: Dusan Bolek <spambin_at_seznam.cz>
Date: 30 Jan 2006 02:02:52 -0800
Message-ID: <1138615372.401926.193740@f14g2000cwb.googlegroups.com>

I'm currently encountering a weird problem with one query. Because I want to look into how CBO is treating this query, I tried using event 10053. Before running a statement I'm issuing:

alter session set events '10053 trace name context forever, level 1';

then run a statement and afterwards:

alter session set events '10053 trace name context off';

The problem is that in the UDUMP trace file there is only QUERY section with shown statement, but no other information. Oracle is in version 9.2.0.7. On my testing 9.2.0.6 this event is working flawlessly. Because I known that the plan is going to be displayed only if the statement issued was hard parsed, I also tried ALTER SYSTEM FLUSH SHARED_POOL, but with no success.

Did anyone encouter similar problem?

Thank you

Dusan Bolek Received on Mon Jan 30 2006 - 04:02:52 CST