Re: temp tablespace

On Nov 18, 4:22 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Nov 18, 2:25 pm, markg22..._at_yahoo.com wrote:
>
> > ORACLE 8i     (we are in process of upgrading to 10g).
>
> > UNIX solaris 5.8  (we are moving to new box).
>
> > optimizer_mode = choose
>
> > Does anyone know if the size of the temp tablespace is used to create
> > an execution plan ?
>
> > If we significantly increased its size, could the execution plan
> > change   ?
>
> > Thank you.
>
> Hi,
>
> This is a legitimate question, so thanks for asking it!
>
> Jonathan Lewis' book on the Cost Based Optimizer is really useful.
> Also, google for "10053 trace" (or read some of Charles Hoopers posts
> in this newgroup) for how to pick apart exactly how Oracle builds an
> execution plan.  It will tell you exactly which components it
> considers when deriving a plan.
>
> It's actually pretty interesting stuff.
>
> HTH,
>
> Steve

Thank you all very much. Received on Wed Nov 19 2008 - 08:15:36 CST