Re: Temp tablespace Database File Overgrown (20 Gigs)

Walt wrote:

>
> 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.

Just for fun ... share the results:

SELECT tablespace_name, status, contents, extent_management allocation_type
FROM dba_tablespaces;

Just in case it isn't the obvious.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)