Re: EVENT 10053 not working

"Dusan Bolek" <spambin_at_seznam.cz> ha scritto nel messaggio news:1138615372.401926.193740_at_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?

Is the statement in pl/sql block? If so, you cannot get this info in 9i(you can in 10g).

Regards,
Dimitre Received on Mon Jan 30 2006 - 04:42:50 CST