Re: Size of temporary segment extents

1. Create a temporary tablespace with a conservative or even no storage clause.
2. Run typical user load that creates temporary segments.
3. While running user load examine the size of segments in this temporary tablespace with; SELECT EXTENTS, BYTES FROM DBA_SEGMENTS WHERE SEGMENT_TYPE = 'TEMPORARY';
4. After data is collected, drop the temporary tablespace and recreate with storage clause that matches the activity observed from the query above.

I size initial and next at the block ceil of the average extent size observed.

Craig Wall

keith_at_keithd.demon.co.uk (Keith Davies) wrote:

>There are conflicting recommendations in Oracle's manuals regarding the
>sizing of the default storage parameters for temporary tablespaces:
 

>(1) INITIAL = ks + b; NEXT = ks
 

>or
 

>(2) INITIAL = ks + b; NEXT = INITIAL
 

>Where k is an integer (1-20?)
> s is the sort_area_size
> b is the db_block_size
 

>Which one should I use?
 

>Keith Davies
Received on Tue May 28 1996 - 00:00:00 CEST