Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP tablespace should be temporary or permanent ?
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