Re: Out of control TEMP tablespace

From: sudheer <>
Date: Wed, 20 Feb 2008 04:04:13 -0800 (PST)
Message-ID: <>

On Feb 20, 3:54 am, trub3101 <> 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


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..

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

Original text of this message