Re: Temp tablespace

On 27 Jun 2001 09:33:08 -0700, tim.purcell_at_datelgroup.com (TimP) wrote:

>Hi,
>I've got a general query regarding temp tablespaces.
>
>I know that used space in the temp tablespace is not released
>(pctincrease 0), but if the datafile is set to autoextend, everytime
>new temp segments are to be created, if it finds no FREE space, will
>it autoextend as a first resort, or will it attempt to re-use the
>existing segments.
>
>I've seen a couple of tablespaces where autoextend has been set on and
>pctincrease to 0 and it has kept growing, even though there was not
>much sort space being used concurrently.
>
>Any answers ?

That depends on whether it is a temporary segment for a temporary table or for a sort.

Check out
Oracle8i Concepts
Chapter 4
Data Blocks, Extents, and Segments

Especially, "Extents in Temporary Segments"

Brian Received on Wed Jun 27 2001 - 12:48:22 CDT