Temporary Tablespace

Hi,

We are running 7.3.3 on Sun E4000 and we have got a TEMP tablespace of about 1 GB in size, defined as temporary. Short after startup, the only segment in the TS grows until there is no more space. I see sort jobs, but no sorts on disk (we have 8 MB sort_area_size).

Does anyone have an idea, how/why this space is allocated? May be each sort job allocates one extent? But when the TS was full, we only had 25 sessions and the temp segment had 54 extents, 16 MB each.

Regards
Karl

-- 


----------------------------------------------------------------

Karl Baier         Siemens Business Services - SBS IP 36 M

Phone: +49 89 636 48096				
Email: mailto://Karl.Baier@mchp.siemens.de	
Nerv:  mailto://baier.muc@sni.de				


----------------------------------------------------------------