bdbafh_at_gmail.com (Paul Drake) wrote in message news:<910046b4.0409161848.43cfdcb4_at_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
I use "set autotrace traceonly"
Received on Fri Sep 17 2004 - 01:11:22 CDT
