Re: temp tablespace

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 12 Sep 2004 23:30:51 -0700
Message-ID: <1095057116.634291@yasure>

Shawn wrote:

> what is the best practice for sizing the temp tablespace?
>
> what the best way to free up temp tablespace space?
>
> how to monitor temp tablespace parameters?

Why would you care about freeing up space in the temp tablespace? Oracle manages it ... not the DBA.

That said:
ALTER DATABASE TEMPFILE '/u02/oracle/data/lmtemp02.dbf' RESIZE 100M;

Funny ... probably haven't posted this piece of syntax in two years and here it is twice in 10 minutes.

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

Received on Mon Sep 13 2004 - 01:30:51 CDT