Re: runaway temporary tablespace

From: <christianboivin_at_my-deja.com>
Date: Sun, 28 Jan 2001 18:34:35 GMT
Message-ID: <951onr$3g6$1@nnrp1.deja.com>

In article <950bj8$801$1_at_dahlia.singnet.com.sg>, "WCK" <abramswee_at_yahoo.com> wrote:
> my oracle 8.0.6 is on NT 4.0 with SP6. My new database starts with a
100mb
> temporary tablespace and a 3gb data tablespace but now the temporary
> tablespace has increased to 2.5gb in size. any idea what cause it to
expand
> so drastically and how can i go about to maintain it? it shows to
have over
> 95% in use.
> Thanks.
> WCK
>
>

Hi
Be sure that all your users
have the good setting for the
default tablespace and
temp tablespace

Read about locally managed tablespace
you can have temp LMT
and its very useful
(www.oracle.com/oramag november edition)

HTH
Chris

Sent via Deja.com
http://www.deja.com/ Received on Sun Jan 28 2001 - 12:34:35 CST