Re: Changing optimizer modes

From: Nisar Tareen <ntareen_at_yahoo.com>
Date: 8 Nov 2004 09:30:19 -0800
Message-ID: <6134f1ca.0411080930.9f02595@posting.google.com>

Mill,

By changing of Optimizer will not change the Tempory storage usage.

There is a posibility some one or some process has run a big view, YOu will notice when view are create it use Tempory storage with other things, but usaslly the big temp. storage use I had seen while using query/report/procedures with view from large tables.

Nisar Tareen

"Mill" <mill.h_at_ntlworld.com> wrote in message news:<PCIjd.2$WC.1_at_newsfe2-win.ntli.net>...
> Hi have a oracle 8i db running on a w2k server, currently db is running in
> rule base mode
> but want to change it to choose.
>
> Have tried changing it on a test db, bouncing the database all seems ok,
> except the temp tablespace
> had grown from 700m to 4.5gb why is this ?
>
> Mill
Received on Mon Nov 08 2004 - 11:30:19 CST