Re: Recover some HD, HUGE temporary file

I think the temp tablespace datafile only grows (if autoextend on) when all extents of the sort segment are currently being used and a new disk sort is requested. So it's not that scary. It's just probably 80% of the DBAs' common practice to keep autoextend off for all datafiles. Temp datafiles are not special in this sense.

Yong Huang
yong321_at_yahoo.com

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3bbdcc64$0$8509$ed9e5944_at_reading.news.pipex.net>...
> Also erik set the datafile NOT to autoextend. You expect the temporary
> tablespace to fill and then reuse existing empty segments. however if
> autoextend is on I believe that the file just keeps growing.
>
> regards
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
Received on Fri Oct 05 2001 - 23:31:14 CDT