Re: stored outlines used but wrong plan executed

From: Paul Drake <bdbafh_at_gmail.com>
Date: 16 Sep 2004 19:48:05 -0700
Message-ID: <910046b4.0409161848.43cfdcb4@posting.google.com>

arik_samson_at_excite.com (Arik) wrote in message news:<699f12fe.0409161337.6ec7abec_at_posting.google.com>...
> I wonder if anybody has stumbled upon the same problem:
> Trying to optimize a query in version 9.2.0.4 with a stored outline. I
> manipulated the outline to have the right hints, altered session to
> use the outline, but when I run the query, although the outline is
> used, the wrong plan is executed.
>
> Thanks,
> Arik

How are you determining the execution plan that was used during execution?

From a 10046 trace file?
From a tkprof of a .trc file, with explain=user/pass ? From an explain plan?
from v$sql_plan?

trust the 10046 trace. read it - the raw file. do not trust an explain plan for ( ... ) do not trust

tkprof infile outfile explain=user/pass ...

hth.

-bdbafh Received on Thu Sep 16 2004 - 21:48:05 CDT