temp tablespace
From: <markg22003_at_yahoo.com>
Date: Tue, 18 Nov 2008 11:25:58 -0800 (PST)
Message-ID: <7f180ee5-ba55-4ab5-9552-15602d7ec3e7@n33g2000pri.googlegroups.com>
Date: Tue, 18 Nov 2008 11:25:58 -0800 (PST)
Message-ID: <7f180ee5-ba55-4ab5-9552-15602d7ec3e7@n33g2000pri.googlegroups.com>
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. Received on Tue Nov 18 2008 - 13:25:58 CST