Re: TEMP tablespace problem

From: Alex Ivascu <alex_at_ivascu.comNOSPAM>
Date: Sun, 03 Nov 2002 18:40:37 GMT
Message-ID: <F4ex9.22011$bG.14537@rwcrnsc53>

Make sure that the tablespace type is 'TEMPORARY'.

(select tablespace_name,contents from dba_tablespaces ;)

Alex Ivascu

"Guy" <ni4ni_at_hotmail.com> wrote in message news:d2eb532b.0211030604.444ce2da_at_posting.google.com...
> Hello
>
> Ive been dealing with Oracle for few years now, but havent seen this
> kind of problem before.
>
> When I install a new DB, I usually set a TEMP tablespace with
> 200-500MB of space. And unless the database has really huge sorts,
> this works fine.
> Now I got a DB that was installed by someone else. The TEMP tablespace
> grows and grows and it seems like it isnt cleaned at all. If I set a
> size limit (say 500 MB) it eats it up in 2-3 days and then it gets
> stuck with full tablespace. If I set it to auto-extend it continues to
> grow and in about a week I end up with a 14 GB tablespace (then I have
> to recreate it).
>
> Does anyone have an idea why this happens ? or any solution ?
> Doesnt TEMP tablespace supposed to clean unnecessary data ?
Received on Sun Nov 03 2002 - 12:40:37 CST