Re: Temp Tablespace Full

Temporary Tablespace 101

Listen and learn -
In 7.3 and higher, when a Temporary tablespace is designated TEMPORARY (alter tablespace temp TEMPORARY) the tablespace should never be coalesced because all of the segments being allocated are the same size (pctincrease on TEMP should always be 0). Since this same space is going to be allocated again the next time that a large sort is done, why go thru the hassle of having to re-allocate the same amount of space ?? Leave it allocated to the high water mark, and the next process won't have to reallocate it. Coalescing the TEMP tablespace will deallocate the allocated extents and coalesce them into one huge block of free space. By NOT coalescing the TEMP space, you save on I/O later.

Alan V

Gitesh Haridas wrote in message <01bd62b5$1fc97160$afae1cc4_at_gharidas>...
>I have a Temp tablespace of type temporary.
>I recently had to add additional datafile to allow major joins and sorts
>to go through.
>
>Is there anyway of shrinking a temporary tablespace to reclaim that space,
>after
>the transaction is completed.
>I dont understand. The tablespace is of type temporary.
>
>Any ideas
Received on Thu Apr 09 1998 - 12:18:22 CDT