Re: temp tablespace
From: <sybrandb_at_hccnet.nl>
Date: Tue, 18 Nov 2008 21:25:41 +0100
Message-ID: <1396i4t0d89v45s5ka6kaauuga2mhrmeg6@4ax.com>
Date: Tue, 18 Nov 2008 21:25:41 +0100
Message-ID: <1396i4t0d89v45s5ka6kaauuga2mhrmeg6@4ax.com>
On Tue, 18 Nov 2008 11:25:58 -0800 (PST), markg22003_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.
>
1 The size of the temp tablespace is NOT used to create an execution
plan
2 If you would do that, it would NOT change execution plans.
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Nov 18 2008 - 14:25:41 CST