Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tempspace usage

Re: tempspace usage

From: jame tong <jametong_at_gmail.com>
Date: Wed, 20 Apr 2005 21:46:17 +0800
Message-ID: <264ff934050420064613434fdb@mail.gmail.com>


I think you tune the sql statement to minimize the temp space usage.

On 4/20/05, Yongping Yao <yaoyongping_at_gmail.com> wrote:
> I have a related question. After I run a statement consuming the
> temporary tablespace a lot and commit the transaction, the tablespace
> is not cleaned soon. Then other sessions got an error something like
> "can't extend ...in ..." which means the temporary tablespace is not
> enough. Is there something wrong with the background process?
> Do I have to use a separate temporary tablespace or set the temporary
> tablespace autoextend (which I think is not safe and hard to control
> the datafile size)?
>=20
> --
> Yao Yongping
> Learning Oracle, UNIX/Linux...
> Love Reading, Classical Music, Philosophy, Economics etc.
> Blog: http://blog.csdn.net/
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2005 - 09:50:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US