Re: TEMP tablespace file suddenly increasing in size

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 12 Aug 2003 12:44:00 GMT
Message-ID: <ki5_a.17104$Bc2.14235@news02.roc.ny>

"Randi Wølner" <randiwolner_at_hotmail.com> wrote in message news:bha603$4e0$1_at_services.kq.no...
> Oracle 8.1.7.4 on AIX:
>
> We have the TEMP tablespace in an autoextensible file. The file has
> "suddenly" started to grow. This might have to do with new code (views /
> triggers / packages), and there has also been some bad performance at the
> same time that the increasing size of the TEMP datafile was discovered.
>
> How can we find what code is making the TEMP-tablespace grow?
>
> If we change the datafile option to AUTOEXTEND=NO - what kind of trouble
> might that cause?
>
> Randi W.
>
>
>

IMHO: Temp tablespace should *never* be set to autoextend. A rogue query can cause a lot of grief to you.

A lot of times an abnormal growth in Temp tablespace points to a bad query. For example a query doing a cartesian join and then sorting/grouping the results. Find out who got this error and then inspect the query.

Anurag Received on Tue Aug 12 2003 - 07:44:00 CDT