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

Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP tablespace should be temporary or permanent ?

Re: TEMP tablespace should be temporary or permanent ?

From: Jörg Brüwer <bruewerj_at_cci.de>
Date: Thu, 14 Sep 2000 14:28:41 +0200
Message-ID: <39C0C479.3456AACF@cci.de>

temporary tablespaces in temp mode will never give memoryspace free. The segments, they allocated will be reused of every user. In temporary tablespaces in permanent mode, the segments will be deallocated. And for this action, the system use time, nobody wants to loose.

have fun
joerg

new_dba_at_my-deja.com schrieb:

> Hi,
>
> I am wondering whether TEMP tablespace should be temporary or
> permanent. What is the main difference ?
>
> The TEMP tablespace in our production database is permanent. How do I
> decide whether I will benefit by making it temporary.
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Thu Sep 14 2000 - 07:28:41 CDT

Original text of this message

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