Re: temp tablespace
Date: Tue, 18 Nov 2008 13:16:24 -0800 (PST)
Message-ID: <ca1d5c81-6b1a-4ff8-b142-d836da2fc780@c36g2000prc.googlegroups.com>
Comments embedded.
On Nov 18, 1: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 ?
>
<sarcasm>
Yes, it most certainly does!! The larger the TEMP tablespace the
better the performance!!! You should dedicate an antire disk farm and
consume all of the available space with your TEMP tablespace so your
queries will really FLY!
</sarcasm>
> If we significantly increased its size, could the execution plan
> change ?
>
<sarcasm>
Yes, yes, YES!!! The bigger the better and the better the faster!!!!
Make your TEMP tablespace HUGE!!!
</sarcasm>
> Thank you.
Truthfully, the size of your TEMP tablespace has *nothing* whatsoever to do with how a query plan is generated. Why would you even begin to think that it would?
David Fitzjarrell Received on Tue Nov 18 2008 - 15:16:24 CST