Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: execution plan
0 views
Skip to first unread message
Message has been deleted
DA Morgan
Nov 19, 2008, 12:07:30 PM11/19/08
to
markg...@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 tablespaces is used to create
> an execution plan ?
>
> If we significantly increased its size, could the execution plan
> change ?
>
> Thank you.
> 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 tablespaces is used to create
> an execution plan ?
>
> If we significantly increased its size, could the execution plan
> change ?
>
> Thank you.
It should be irrelevant except should you run out of space.
The size could affect speed but it should not affect the plan.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
0 new messages