10053 traces are only generated when the statement is hard parsed. I use
comments, change case, etc. to make sure the statement is considered
'new' by the optimizer.
Riyaj Shamsudeen wrote:
> Hi All
>
> Due to some issues with mail server DNS entries, my posting to the
> list bounces. I am trying other options ;-)
>
> So, I was working with William off-line and here are the highlights:
>
> 1. I thought, autotrace had dumped incorrect statistics, asked for
> 10046/10053 trace files.
> 2. 10053 trace files were never generated for this SQL. Still,
> don't understand, why ? I think, this must be a bug with 9i. I can't
> test it.
> 3. explain plan filter predicates clearly pointed out the issue.
>
> Of course, metalink documents mentioned here and reference books
> are showing the issues. I recreated the issue before telling William.
> And Wolfgang, as usual, has done a wonderful job of recreating the issue.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 22 2006 - 11:09:25 CST
