Re: Out of control TEMP tablespace

From: trub3101 <trub3101_at_sky.com>
Date: Wed, 20 Feb 2008 04:17:17 -0800 (PST)
Message-ID: <c15e9a93-d1df-4c94-b26f-7c5989c88069@q33g2000hsh.googlegroups.com>


On Feb 20, 12:04 pm, sudheer <sudheerdp..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thanks for your swift reply Sudheer! Received on Wed Feb 20 2008 - 06:17:17 CST

Original text of this message