Temp tablespace Database File Overgrown (20 Gigs)

On one instance, the size of the TEMP01.DBF file is enormous - over 20 Gigs (none of the other .dbf files are more than a gig or so) This has maxed out the disc space - apparently it's just grown until the disk has become full.

Now, according to my research (limited, so far) this should clean itself up automatically eventually, and bouncing the instance should clean it up right away.

That is not my experience. Bouncing the instance has no effect.

Any suggestions? Since this is temp data, I should be able to throw it away with no ill effect, right? Unfortunately, I'm not sure how to dump the temp data.

BTW, I've verified that there are no permanent objects in the temp tablespace (SELECT * FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = 'TEMP';)

sort_area_size == 524288
Oracle 9.2 on W2k3.

-- 


//-Walt

//

//