Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange problem.
"Chuck" <skilover_nospam_at_softhome.net> wrote in message
news:Xns97249A478C434skiloversofthomenet_at_213.155.197.138...
> DA Morgan <damorgan_at_psoug.org> wrote in
> news:1133899013.503150_at_jetspin.drizzle.com:
>
>
> > Play with the NO_UNNEST and UNNEST hints.
>
> That essentially what I did in the OP. My problem is that the explain plan
> being chosen by the optimizer when I actually run the SQL appears to be
> different than what explain plan says it's going to choose. I'm
> determining this with sqltrace and tkprof. Is the execution plan reported
> by tkprof guaranteed to be what actually executed?
Can't you create a stored outline? That should help with plan stabilioty.
-- Terry Dykstra Canadian Forest Oil Ltd.Received on Tue Dec 06 2005 - 14:22:37 CST