Re: temp tablespace and extents

Joanne Woytek (joanne_at_eosdev1.gsfc.nasa.gov) wrote:
: If I have a temp tablespace with initial extent of 10K and secondary extents of 5K and
: maxextents of 100, are those numbers per user? That is, if 2 users perform a sort at
: the same time does each user start with an extent of 10K or does the first one get the
: 10K segment and the second start with a 5K segment (since the initial temp extent was already
: done). Similarly is each user allowed a maxextent of 100 or must the sum of both users
: extents remain below 100.
 

: I am assuming the extents are done per user, but would like to verify that.

: Thanks.
 

: Joanne Woytek
: Code 902.2
: NASA/GSFC
: joanne_at_eosdev1.gsfc.nasa.gov

The storage parameters apply to each object created in the tablespace. In your case, it is each temporary segment, or each sort which cannot fit in memory. So technically, it is per sort, not per user, as each user can have more than 1 sort going.

BTW, your initial and next extents should be multiples of (SORT_AREA_SIZE+DB_BLOCK_SIZE) and PCTINCREASE 0 or 100, or else you'll be wasting space.

Hope this helps,
Gary

--
Gary Kirsh
Next Extent, Inc.
Phone: (718) 380-8546
Internet: gkirsh_at_dorsai.org