Re: Out of control TEMP tablespace
Date: Wed, 20 Feb 2008 04:04:13 -0800 (PST)
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?
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