Re: runaway temporary tablespace

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Sun, 28 Jan 2001 15:10:00 +0900
Message-ID: <aEOc6.67573$9D3.3100496@news.hananet.net>

if SGA size is too small then most of sort will be worked in temporary tablespace.
check your temp tablespace is 'temporary' (not permanent) and size of buffer cache.

"WCK" <abramswee_at_yahoo.com> wrote in message news:950bj8$801$1_at_dahlia.singnet.com.sg...
> 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
>
>
Received on Sun Jan 28 2001 - 00:10:00 CST