Re: temp tablespace

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 Received on Tue Nov 18 2008 - 15:22:18 CST