temp tablespace and extents

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 Received on Tue May 30 1995 - 00:00:00 CEST