Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why isn't Oracle Using My Index

Re: Why isn't Oracle Using My Index

From: Daniel W. Fink <daniel.fink_at_optimaldba.com>
Date: Fri, 22 Dec 2006 10:09:25 -0700
Message-ID: <458C1145.5040804@optimaldba.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US