Re: Temp tablespace storage parameters

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 15 Oct 1999 09:19:10 -0700
Message-ID: <380753FE.CFEC2142@us.oracle.com>

Tony

Temporary tablespaces don't need coalescing. If you leave PCTINCTREASE at zero, then every temporary segment created in a particular temporary tablespace should pick up the INITIAL and NEXT values defined in the DEFAULT STORAGE clause for the tablespace. Provided INITIAL and NEXT are set to the same value, every temporary segment will use the same extent sizing, so why bother coalescing?

HTH. Pete

Tony Adolph wrote:

> Hello All,
>
> Is there any reason why temporary tablespaces should have pctincrease=0
> as this switches off automatic coalescing? (At the moment I regularly
> coalesce my temporary tablespaces manually otherwise I get unable to
> throw extents problems {as you would expect}).
>
> Thanks in advance
> Tony
>
> PS - Ora 7.3.4 Nt4
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Fri Oct 15 1999 - 11:19:10 CDT