Re: Out of control TEMP tablespace

On Feb 20, 3:54 am, trub3101 <trub3..._at_sky.com> wrote:
> Hi Gurus,
>
> Unfortunately, in our LIVE database the TEMP tablespace is set as
> UNLIMITED for max size with autoextend on.
> The tablespace was originally sized for 1000 MB but in the space of a
> few days has grown to over 25000 MB as a result of this my filesystem
> where this temp file is based is creaking!
>
> A couple of things;
>
> a) How can I reset the TEMP tablespace back so that it only grows to a
> more manageable size without bouncing the database?
>
> b) How do I decipher what caused this considerable growth in such a
> short space of time?
>
> Cheers,
>
> tb3101

hi

try to create a new temp tablespace and make sure u give the max size clause.. and make it default ..
and then drop the old temp tablespace..

regards
sudheer Received on Wed Feb 20 2008 - 06:04:13 CST