Anno Domini 26-4-2005 0:24, Walt sprak aldus:
>
> 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.
>
>
Drop the tablespace, delete the tempfiles and recreate it with maxsize
on the tempfiles.
Received on Tue Apr 26 2005 - 00:19:28 CDT
